That works. I will give Cap1 the majority of points since he was first. One question though before finalizing.
Why on the qry results is that number left justified? Any other number that is currency formatted is right justified. Just a pet peeve. When I go to the home tab and select that column in the results I can not select the right justified formatting.
PS One other issue. On my qry table I have selected the "TOTALS" of records. For the other columns that it brings in I can tell it to "Sum" the column. However for that AJE's column the only options it gives is None or Count. There is no Sum option.
wlwebb
ASKER
Ah ha, So how can I change that stmt to format it as a Currency NUMBER.
Why on the qry results is that number left justified? Any other number that is currency formatted is right justified. Just a pet peeve. When I go to the home tab and select that column in the results I can not select the right justified formatting.