View Single Post
  #1   Report Post  
 
Posts: n/a
Default Using the AND function with fractions

I have three data fields that I wish to concatenate. Two of these
fields are fractions. However, when I use the AND function to
concatenate them together the fractions are displayed as decimal
inches.

Here's what is happening now:

SR1001 5/8 13/16 Result: SR1001 0.625 0.8125

Here's what I need:

SR1001 5/8 13/16 Result: SR1001 5/8 13/16