Group Query

  • Thread starter Thread starter lez
  • Start date Start date
L

lez

I am sure there is a simple answer to this, but cannot find it. I want to
create a query to simply count the number of calls name in a day.

I have tblcalls with callsID, contactID, df1, notes,

df1 date stamps the record and I simply want a 'count' of df1 for Now()
grouped by contactID.

anyone any suggestions?

Thanks
 
I am guessing that DF1 contains a date along with the time. The SQL for the
query would look like the following.

SELECT ContactID
, DateValue(Df1) As DateOnly
, Count(CallsID) as CountCalls
FROM tblCalls
GROUP BY ContactID
, DateValue(Df1)

If you can't figure out how to use this, then post back for instructions on
how to build the query in the query design view instead of in the SQL view.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Thanks John,

I have just reposted as I was not sure if my message was clear, the post is
header 'date query'

I am trying to do this is query design window, so help would be appreciated.

Thanks
Lez
 
SELECT ContactID
, DateValue(Df1) As DateOnly
, Count(CallsID) as CountCalls
FROM tblCalls
GROUP BY ContactID
, DateValue(Df1)

-- Open a new query
-- Add your table
-- Add the fields ContactId, Df1, and CallsID
-- Change DF1 to DateValue(Df1)
-- Select View: Totals from the menu
-- Change GROUP BY under CallsID to Count
-- Run the query.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Cheers John, got it now, many thanks


John Spencer said:
SELECT ContactID
, DateValue(Df1) As DateOnly
, Count(CallsID) as CountCalls
FROM tblCalls
GROUP BY ContactID
, DateValue(Df1)

-- Open a new query
-- Add your table
-- Add the fields ContactId, Df1, and CallsID
-- Change DF1 to DateValue(Df1)
-- Select View: Totals from the menu
-- Change GROUP BY under CallsID to Count
-- Run the query.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
Click to expand...
 
Back
Top