query by day, week, month, year

G

Guest

What are the expressions for:
query by day
query by week
query by month
query by year

I need to be able to count items by day, week, month and year.
Also where is this information located for reference.
 
J

Jeff Boyce

Not sure your definition of "query by day" and mine are the same...

What is it that you are querying? Does the data have a field with a
date/time value in it?

More information, please...

Jeff Boyce
<Office/Access MVP>
 

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

Show query per day by specific month 1
Querying Date Field, Disregarding Year 2
Query for previous week, Sun thru Sat, from date field 1
Excel Vba to change displayed year automatically. 14
Month, DATE, Week 7
Sorting by month 3
Year and Week Totals 2
SUM in a UNION query 2

Top