Need help with account rec aging

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

.

Relevant Pages

  • Re: Three tables issue still remains
    ... In your case, as mentioned, just built a query on the main customer table ... So, if we have Customers, and Invoices tables, a left join would give us: ... REGARDLESS if the child records ...
    (microsoft.public.access.gettingstarted)
  • Re: Calculated Value will not store in Table
    ... A left join means that a query will return the "parent" records when the ... So, if we have Customers, and Invoices tables, a left join would give us: ... The tables that MUST have a child records can also clearly be seen. ...
    (microsoft.public.access.forms)
  • Re: Summary Query based on First Occurrence
    ... "Jason Lepack" wrote: ... Did you change all 4 occurences of Account? ... Invoices AS B ... You tried to execute a query that does not include the specified expression ...
    (microsoft.public.access.queries)
  • Re: Summary Query based on First Occurrence
    ... I created this query using the table structure you clarified above. ... INNER JOIN (dbo_INVX AS I ... (Many to many relationship accounts to invoices) ... AccountDirKey - relates to dbo_WACCT.AccountDirKey ...
    (microsoft.public.access.queries)
  • Re: Need help speeding up 25 minute query
    ... figure out over-due invoices by matching all invoices' total to their payment ... When I use first query as an input to a second query, ... If you then replace the temporarily dropped indexes, ... > Tom Ellison ...
    (microsoft.public.access.queries)