2 date fields

D

diana2ke

My db looks like this:
Invoice: InvoiceID, InvoiceDate, Invoice Value
Pay: PayID, PayDate, PayValue, InvoiceID

I made a query to show me the due Invoices, my debt to my supplier, (the
invoices not paid). Ive created a query Q: InvoiceID, InvoiceDate,
InvoiceValue, PayDate, PayValue; Sold: [InvoiceValue]-Nz(Sumă([PayValue]),0)

For InvoiceDate I've set the citeria: Between [forms]![filters]![Data1] And
[forms]![filters]![Data2]

If I run the query till the current day it works, but I need also the result
for InvoiceDate between ex: 01.01.04-30.04.04 and payments utill 30.04.04 or,
otherwise said: i need my debt to the supplier at a certain date in the past.

Can you help me?
 

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

Similar Threads

criteria for 2 date fields from 2 tables 2
eliminating duplicate records in select query 1
Dynamic range of report 6
Invoice Amt. - Payments = Balance 2
Year To Date Record Selection 3
SQL Query Double Counts on Multi-Table Query 3
Aging Invoice Report 8
Help With Date Calculation Query 4

Top