Expressions from query not displaying on report

R

Rick

I have two fields that are calculated and give me the result I want in my
query, but when I put them onto the report they do not display any data.

One of the expressions is this
Expr1: Nz([NON PSC PO Account Totals]!SumOfPDFRRC,0)+Nz([PSC PO Account
Totals]![Sum Of PDAEXP],0)

The other is Expr2: [Budget]-[Expr1]

As I said, the calculations work fine in the query but the data won't
display on the report. Any help would be appreciated. I am very novice with
Access so it could be something really simple I don't know about.
 

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

Cross Tab Report Vs Dynamic coulmns 0
Using expressions in a report to calculate pay 1
Creating a Chart on form from selected data in query. 0
Convert blanks to 0 in report 3
Compare results of two expressions within query 1
optimized way to make a report? 14
Completely Blank Report...no title, data, etc. 3
Showing Totals from Subreport on Main Report 5

Top