Code Assistance - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Code Assistance

Carl Byerley

2 years ago

I am working on an Accounts Receivable Report, In this report I have a field for "Days Past Due" My calculation works fine however, if an account is not past due it will display (for example) -9. I only want to display actual days past due if it is not past due the value should be blank not -9.
Can someone help with the criteria I should write into the query?

	Carl Byerley OP @Reply 2 years ago

	Sami Shamma @Reply 2 years ago
Share your calculations.

	Gary James @Reply 2 years ago
use an "iif" statement. textbox = IIF( calculation < 0, calculation, "")

	Ludwig Willems @Reply 2 years ago
volgen :)

	Adam Schwanz @Reply 2 years ago
Like Gary said, you could use an IIF Function

	Richard Rost @Reply 2 years ago
Gary's got it. `PastDue2: IIF(PastDue > 0, PastDue, 0)` Or based on what you have right now, you could jam it all in one field.

	Gary James @Reply 2 years ago
Richard, you're right. I misunderstood and thought he wanted to display the calculation result if the answer was less than zero. The devil is always in the details. I'll chalk it up to another senior moment. I turned 74 today. 8^)

	Richard Rost @Reply 2 years ago
Happy birthday

	Ludwig Willems @Reply 2 years ago
If I continue with access until I'm 74, then maybe I'll be as good as Richard :) LOL, and yes, happy birthday.

	Sami Shamma @Reply 2 years ago
We students will never be as good as the teacher.

	Carl Byerley OP @Reply 2 years ago
Thanks for all the input, I am on the right track I knew it was an IIF, just having trouble with the syntax. I would like as Richard commented in one field. I should have showed a little more information. Here is img of query and results I am getting. How would I put these together to only show positive number results.

	Carl Byerley OP @Reply 2 years ago

	Carl Byerley OP @Reply 2 years ago

	Ludwig Willems @Reply 2 years ago
Sami, don't be so modest, man......miracles still happen sometimes.....

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View