Counting records

[frustratedwithaccess]

Hi All,

I am hoping someone can help with a counting issue I am having...How can I count the number of records in a field (of a query) and ignore the differences in the data? For example, I have a query with multiple fields that can be grouped according to "ProjectNumbers", "SampleDates", "SampleTime" etc. The field that varies is my "Species" field. It has a list of different animal species observed according to the above fields. In any given project, on an given day or time there can be multiple species listed, one species listed, or no species listed. All I need is to count the number or records for a given project number, date and time, regardless of the species. For example, if there are 5 species listed, then I want access just to count the number of records, which in this case will be 5.


my data looks like this

ProjectNumber SampleDate etc etc Species
1 Mar 23/15 zebra
1 Mar 23/15 zebra


1 Mar 23/15 elephant
1 Mar 23/15 gazelle

[orange]

Have you looked at the SQL tutorial at w3schools and the Count function

You may also research the Group BY while you are there.
Work with the tutorial an some examples--you'll learn by doing.

Good luck.

[frustratedwithaccess]

Have you looked at the SQL tutorial at w3schools and the Count function

You may also research the Group BY while you are there.
Work with the tutorial an some examples--you'll learn by doing.

Good luck.

Yes, I understand the concepts of Group By, and have also looked at the count functions...Unfortunately I have not been able to count and display the records as I'd like to, hence posting here.

Anyway, thanks for the post

[orange]

Post your table designs and the sql you are using/trying.

[orange]

All I need is to count the number or records for a given project number, date and time, regardless of the species

Select count(ProjectNumber) from YOURTableName
Where SampleDate =[Enter a SearchValue in Mar 23/15 format]

Note: You don't indicate that you store a time value in your example data.