Count based on Unique Field + more detail provided in post

[accessmatt]

Hello, can anyone help with a query that counts ONLY ONCE the number of records within a data set only once based on Tactic ID, when there are multiple rows of equal tactic ids with different time stamps?

Tactic ID	Time Stamp
1	5/27/2015 9:00
1	5/27/2015 9:03
2	5/28/2015 8:02
2	5/28/2015 8:05

[ItsMe]

You don't have a PK value that you can use the Count() function on? I would probably use DAO and get a .RecordCount