noob needs help (1 Viewer)

[anthonyphillips]

Hi Guys

i have created a table and am trying to run a qry that counts specific data, i have been searching but cannot find the answer. I have a standard qry that has the criteria of "staff name" and dates between ## And ##. Now when that information is returned, how do i get a count figure for the results. So for example if there were 15 entries for september it would say september = 15 (ish). I have been told to assign a recordset but no other information was forth coming. Can anybody help with code or qrys for creating a recordset.

Please remember the noob status when it comes to access - lol

Cheers Guys

Anthony

 

[wazz]

click on the 'totals' button at the top of the query designer (sigma). select 'count' instead of 'group by'.