count by month

S

smason

Hello i have a query which has the following

placement id date placed
1 01/01/2006
2 02/01/2006
I have the format sett to mmmm-yy so it reads january 06 not 01/01/2006

when i try to count how many entries are for january i get the following
results
month count
january 1
january 1

instead of
january 2

any ideas please
 
A

Allen Browne

In the Field row of your query, enter:
Format([date placed], "yyyymm")

That gives you a 6-digit number (4 x year + 2 x month), which will sort
correctly.

Alternatively, use 2 fields (i.e. 2 columns of the Field row):
TheYear: Year([date placed])
and
TheMonth: Month([date placed])
 

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

Top