Invoices outstanding at end of year

M

Mellstock

I am running Access 2000 on Windows XP. I need to design a query that
will give me all the invoices in a database outstanding at the end of
the UK Tax year. I can find all the records for the year OK. I have
fields for Amount (Amount Invoiced) Payment (payment received) and
Date (Payment Received).

The year I need is 06/04/2007 to 05/04/2008 no problem with that.

What I need to get into a single query is to identify those records
where Payment = 0 and identify those records where the Payment may
have been received but after 05/04/2008. An Or query I presume. Either
0 on Payment OR > 05/04/2008 on Date field.

For the sake of this query I need to reset Payment to 0 if it was
received after 05/04/2008. Can I use some sort of expression along the
lines of If [Date] >05/04/2008 [Payment] = 0. If I can how can I use
it in a query.

Thank you.
 
I

Irene

hi Mellstock,

sorry to ask that u want the query is want to set the criteria to payment =
0 and the date must be after 05/04/2008? or either one? means that the result
u want is either payment =0 will be come out and after 05/04/2008 also will
be coming out too.

then about the "For the sake of this query I need to reset Payment to 0 if
it was received after 05/04/2008. Can I use some sort of expression along the
lines of If [Date] >05/04/2008 [Payment] = 0. If I can how can I use
it in a query." u want it update before the result coming out or after the
result, then u just want to reset it to 0 for those the date is after 5/4/08.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top