I am trying to build a database to track employee activity by month. I need to be able to query the main table and produce a report for each quarter and annually. I have the annual report working, but cannot seem to get the quarterly report to work. I have entered January, February, March into the criteria field, but when I do I get no results from the query. If I leave the criteria field blank the Query runs and returns data for the entire year. Any help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Querying a table
- Thread starter dhelvey
- Start date
JerryDennison
IS-IT--Management
Try adding this to the criteria:
Between [Enter Beginning Date] And [Enter Ending Date]
Between [Enter Beginning Date] And [Enter Ending Date]
ChiTownDiva
Technical User
Or you could use the "DatePart" function in your Date field as a criteria in your query.
DatePart("q",[OrderDate])=4
What this is doing is displaying orders placed for the 4th quarter.
Hope this helps.
DatePart("q",[OrderDate])=4
What this is doing is displaying orders placed for the 4th quarter.
Hope this helps.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
