Adding information to a table

[stephanie]

I have a table called productivity and a query coming from
that table to get information for a specific date. I would
like to be able to have a form to add the number of hours
worked per ID.
For example I would like when I open the form to see
for 2/21/05
ID Cases
ABC 2
DEF 3
GHI 2

 

[John Nurick]

Hi Stephanie,

Make a copy of your query (or create a new one). Open it in design view.
Click the Totals button on the toolbar (the one whose icon is a Sigma,
like a M on its side). Then add calculaed fields that get the totals you
want, and finally set it to Group By your ID and date fields. Finally
base your new form on that query.

The query will look something like this in SQL view :

SELECT ID, TheDate, COUNT([ID]) AS Cases,
SUM([Hours]) As HoursWorked
GROUP BY ID, TheDate
ORDER BY ID;