Concatenate with good lineups 1

[molly]

I am trying to concatenate 2 fields which will decently line up. I am take a Price and a Size. The Price is in 2 decimal format. I do not want the data to "snake" in a report. Here is what i have so far.

PriceSize: Format([Price],"Fixed") & " - " & [Size]

However, when i run the query, i get snaking like this:

PriceSize
2.95 - 1 LB
12.75 - 5 LB
31.25 - 25 LB
0.85 - 50 LB
20.00 - 35 LB
1.25 - 50 LB
6.41 - 1 LB
12.25 - 0
19.00 - 25 LB
203.75 - 25 LB
46.25 - 5 LB

is there commands in this field to make things line up nicely?
thanks
Molly

 

[molly]

Just thinking. The Size field is really 2 fields: a number and a text that i had combined as Size. So EG, if i had 25 LB and 1 LB, i should use commands on both Size pieces and not combine them. that way, the 25 and 1 would lineup and the LB would line up.

 

[molly]

Here is what i mean.

Usp Size: Format([Curr USP],"Fixed") & " - " & [PackWeight] & " " & [PackWeightUom]

and then use some kind of commands around the 3 fields to make them line up.
mollie

 

[PHV]

You may try something this:
Usp Size: Right(" " & Format([Curr USP],"Fixed"),8) & " - " & Right(" " & [PackWeight], 3) & " " & [PackWeightUom]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[molly]

Thanks PHV. This helps me alot. It is a perfect solution. Molly