Its Null values again!

G

Guest

I have a table,"Students" and a query"TotalPayments" in a query
"PaymentsAllStudents". "SumOfPayments" from "TotalPayments" has an alias
field CostTotal:Nz([SumOfPayments]) in "PaymentsAllStudents". There is
another query, "Balance" that calculates the balance from
"PaymentsAllStudents" and another query, "TotalTuition".The problem is that
"CostTotal" shows up in a report based on "Balance", as a number with 2
decimal places or 0, but not as currency. I have set the properties format in
all queries and the report to currency for the "CostTotal" field. How do I
get the field to recoginize currency as the format?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select query works until I put in criteria 1
Query Calculations & 2
Calculated Query 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
FORMATTING RESULTS IN CALCULATED FIELD 4
How do I get Access to append the exact amount with decimals? 2
Query not totaling correctly 3
Query Field Format 2

Top