Results 1 to 1 of 1
  1. #1
    jonnyuk3 is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    4

    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

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums