Need help with account rec aging

[erick-flores]

Hello all

I have been searching in different groups to find an answer for these
but no luck.

I have a table that has invoice_num, total (amount), invoice number,
etc.
I want to create a query to show the aging of the invoices like:
Current, 31-60, 61-90 and 90+. How do I do this? I know an IF statement
will work, but I just dont know how to write the correct statement.
Also I want to be able to type a date and run the query against that
date, in other words if I want to see the invoices until 12/31/2006 the
user will type 12/31/2006 press enter, and then the query will run and
show all the results.

Thanks in advance

 

[erick-flores]

Thank you very much for your help. Now I have a better understanding of
the IIF statement.

Question 1:

The if statement works like this:

iif([value] = [value],[answer if true],[answer if false])

you can test for any condition (<,>,=, between, is, ect.).

leave out the [ ] brackets unless you are using a field name.

Question 2:

The easiest way would be to use [ ] around text in your query criteria
Example:

[Enter date]

This will prompt the user to enter a date when the query is run.


In the future please post questions as questions. When someone gives a good
answer you can give that person a pat on the back hitting yes on the "Was
this post helpful". It also helps others searching for valid answers.

thanks!
Robert

Hello all

I have been searching in different groups to find an answer for these
but no luck.

I have a table that has invoice_num, total (amount), invoice number,
etc.
I want to create a query to show the aging of the invoices like:
Current, 31-60, 61-90 and 90+. How do I do this? I know an IF statement
will work, but I just dont know how to write the correct statement.
Also I want to be able to type a date and run the query against that
date, in other words if I want to see the invoices until 12/31/2006 the
user will type 12/31/2006 press enter, and then the query will run and
show all the results.

Thanks in advance

 

[erick-flores]

One more question, hopefully you can help me

How can I count the different invoice aging in a form?

This is what I want to see in my form:

Current: 89 Invoices View
31-60: 34 Invoices View
61-90: 87 Invoices View
90+: 34 Invoices View

"View" would be a button where the user can click and see all the
details.

Do you know how to do this?

Thanks in advance