Number registered for a month

[jsiimml]

Hi, I have a customers table with the following structure:

- id (auto number)
- datecreated (date/time)

I wish to return the the number of people who have registered for the current month and previous 3 months. Appreciate the help. Thanks

 

[PHV]

Typed, untested:
SELECT Count(*) AS CountOfRegistered
FROM tblCustomers
WHERE Format([datecreated],'yyyymm') BETWEEN Format(DateAdd('m',-3,Now()),'yyyymm') And Format(Now(),'yyyymm')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jsiimml]

Genius worked a treat. Thanks