need 1st and last date of customer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a query that will display the first and last date a customer attends
during a month, how do i do this? Thanks
 
Iain said:
I need a query that will display the first and last date a customer attends
during a month, how do i do this? Thanks
Click to expand...

(air code)

For all months...

SELECT Format(AttendDate, "yyyy-mm") As Month,
CustomerID,
Min(AttendDate) As FirstDate,
Max(AttendDate) As LastDate
FROM TableName
GROUP BY Format(AttendDate, "yyyy-mm"), CustomerID

For a given month...

SELECT CustomerID,
Min(AttendDate) As FirstDate,
Max(AttendDate) As LastDate
FROM TableName
WHERE AttendDate BETWEEN #1/1/2005# AND #2/1/2005#
GROUP BY CustomerID
 
You must log in or register to reply here.

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

Access query for last date entered 4
complicated query 1
last date attended query 1
Excel Message box with days of month & date. 1
Date query 4
1st date, and last date of a given month in access? 3
Data Type Mismatch in Criteria Expression 2
Access SQL - Most recent child record 5

Back
Top