Two Fields Aligned in one calculated field a Qry 1

[molly]

Can you please help me get this Qry calculated field to line up better? I need to have both answers in one field for my Price List. I would like the LB to line up and the price to be right aligned. I presently use the below in the Qry. Thanks

SizePrice: Right([Size],8) & " " & Format(Round(nz([Price]),2),"Fixed")

SizePrice
5 LB 4.56
25 LB 6.12
25 LB 5.15
1 LB 4.51
1 LB 3.75
1 LB 18.53
25 LB 16.50

 

[PHV]

Perhaps this ?
SizePrice: Right(" " & [Size],8) & Right(" " & Format(Round(Nz([Price],0),2),"Fixed"),10)

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

 

[molly]

Thanks again PHV. I slightly modified your code. only a tad. It will do. A lot better than what i had.

SizePrice: Right(" " & [Size],6) & Right(" " & Format(Round(Nz([Price],0),2),"Fixed"),8)

Here is what i get now in my crosstab. Not bad. Better than a 2 value crosstab or pivot table for this instance.

Attached is a BMP file showing that most of the data lines up. Molly