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