Query Format as number 1

[cimoli]

My calculated field below works. But the number is left justified in the query grid.
Is there a way for this calc to be right justified like a normal number?

I was thinking of the Format Function but i am not sure.

NumNights: DLookUp("[NightsIN]","tblTravelDetail","[tblTravelDetail]![TripID]=" & [tblReservation].[TripID])

thank you.

 

[dhookom]

Wrap the expression in Val() to make it numeric.

Duane
Hook'D on Access
MS Access MVP

 

[cimoli]

thanks Duane. it works for me.