Microsoft Access

  • Thread starter Thread starter Stef Robinson
  • Start date Start date
S

Stef Robinson

I have a Call Log Database in Access. I am wanting to produce a query
which will count the number of calls that have been logged each month.
I have got a date field in the database which is a date/time
(dd/mm/yyyy) field.

In an ASP page, I want to display the month, and then the number of
calls logged that month. I have managed to get a query that strips
out the day and just displayed the month and the year. e.g. 10/2003.

MonthNum: Month([srdate]) & "/" & Year([srdate])

How would I then count the number of occurances, in order to display
that on a webpage?
 
Stef

It sounds like you are saying you want to run a query for a date range
Between Date1 And Date2
where Date1 is (1/mm/yyyy) and Date2 is (1/mm+1/yyyy) - 1.

If so, check the Between...And... expression, and check the DateSerial()
function in Access HELP.

Good luck

Jeff Boyce
<Access MVP>
 
Create your query, in your date logged field, add the
criteria
Month([DateLogged])=Month(Now())
 
Back
Top