How to track/count the occurence of a particular field

[jessica.ann.meade]

Hi,

I'm creating a VERRRY simple database (seriously, there are two columns of inputted data), but I am have difficulty in the Report-building phase.

First let me identify the two pieces of data I am working with:

Field A - Date of the Occurence (in this case teleworking)
Field B - Staff Member


I am interested in finding out what function/formula/etc I can use to add to the report subtotals of the number of entries for each Field B-item over a given period of time - in our case a month.

Please let me know if you need any clarification!

[TheShabz]

I take it you want to count how many times a staff members has teleworked.

SELECT StaffMember, count(StaffMember) As Occurences
FROM tableName
GROUP BY StaffMember

if you want some sort of a timeline, you will need to include a HAVING clause, something like:
HAVING OccurenceDate >= #1/1/2011#
which will count how many telework days each staff member has had this year.

[jzwp11]

You will need a query. Does your data span multiple years?

Something like this should work (SQL view)

SELECT month(FieldA) & "/" & year(fieldA) as Period, fieldB, Count(fieldB) as CountOfB
FROM yourtablename
GROUP BY month(FieldA) & "/" & year(fieldA), FieldB

[jessica.ann.meade]

Thank you all for the feedback. I think I've got most of it worked out, I just have one more issue.

Can't seem to figure out the syntax of and where to place a string so I can input a date parameter (like "02/01/11 to 02/28/11") when generating a report.

[jessica.ann.meade]

Nevermind, I think I've figured this out.

Thanks again!