By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,039 Members | 1,831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,039 IT Pros & Developers. It's quick & easy.

If statement in reports

P: 12
I have summed all "Actual production" in a report. I need to sum all " Packaged production " in a report. I have a check box "Inspect only " . "Packaged Production" is all the "Actual Production" minus the Actual production which have "Inspect Only" checked. How do i do this in a report? an IF statement?

Kindly help.
Oct 27 '06 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,221
Try adding Actual Production to you underlying recordset. You can build it into a query
Expand|Select|Wrap|Line Numbers
  1. PP: IIF([InspectOnly],0,ActualProduction)
That will return zero if the instpectonly flag is set, the ActualProduction value if it is not set.

Jim


I have summed all "Actual production" in a report. I need to sum all " Packaged production " in a report. I have a check box "Inspect only " . "Packaged Production" is all the "Actual Production" minus the Actual production which have "Inspect Only" checked. How do i do this in a report? an IF statement?

Kindly help.
Oct 27 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.