access date query criteria
Posted on 2011-02-28
Mental block over query criteria:
I have a sales date field [date of sale] and I want separate criteria for two separate queries.
The first query is " which clients have placed a sale in the last 30 days" by reference to clients records
The other is message box "those clients which sales since have taken place since [insert date]"
Each client has its own record. the two queries are stand alone.
Just need the criteria for the date field query.