-
Help with a query
the table contains five fields,
Customer, Total, Deposit, Balance, Delivery Date.
I am trying to return data for a given date range if Deposit + Balance = Total.
How can i do this using a query?
Solved!
Under criteria of Total:
[table].[Deposit] + [table].[Balance]
Under criteria of Delivery Date:
Between [Start Date] And [End Date]
Thanks,
jonnyuk3
Last edited by jonnyuk3; 06-12-2009 at 06:00 AM.
Reason: Solved
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules