asked on Access query Expression - Convert to Currency Formatted Number
This is a follow on question to one earlier today. That question discussed summing of Accountant AJE's based upon acct_numb and PdEndDate.
The solution brings in the correct total but I want the query to have the total formatted as a number in currency format.
Currently the code I used in the Builder is as follows:
AJEs: (FormatCurrency(nz([qryAcc
When I use the results in subsequent queries it isn't seeing that number as a currency number. Am I doing something wrong?
The solution brings in the correct total but I want the query to have the total formatted as a number in currency format.
Currently the code I used in the Builder is as follows:
AJEs: (FormatCurrency(nz([qryAcc
When I use the results in subsequent queries it isn't seeing that number as a currency number. Am I doing something wrong?
Microsoft Access
Last Comment
wlwebb
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
ASKER
Ah ha, So how can I change that stmt to format it as a Currency NUMBER.
ASKER
Forget that last. Just found it.....CCur(expr). Thanks all!
right click on the column > properties
Format Currency
Format Currency
ASKER
Tried that earlier and the "Format" section was blank. No options. Probably was trying it when my expression was incorrect. I see that now. Thanks
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.