Web Development

Ask something
Question Locked

Queries

0 helpful
2 replies

by joyce_wright5 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am using Microsoft Access and its been a while since I have had to create a query. The table is a Membership table and I need to know how many membership on a month to month basic has joined. For example #01/01/07# thru #05/01/07#. I need some help on how to put this to use the correct way. Could some one help me please. Thanks In Advance!!!!

2 replies

by tony hopkinson

Select Month([DateJoined]),Count([MemberID])
From [Membership] Where ....
Group By Month([DateJoined])

If the date range can span a year end then you'll want to select year of dateJoined as well
Note Month returns 1 to 12, if you want the month name You might be better off Format

This will help

http://www.alvechurchdata.co.uk/accdate.htm

This discussion is closed to new replies.