E
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
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