Count Number of Dates on Same Day

[burrina]

I am trying to get the number of dates on the same day. In other words if I enter a date that already exists for that day, then warn! Example Below:

tblCatchDetails
CDte Primary Key
CatchDate Date

[Rudi]

This could be done by indexing the field. Set the field's Indexed property to Yes (No duplicates).

[burrina]

I want to be able to allow duplicates, just warn if one exists!

[HansV]

If you want to count the number:
- Activate the Create tab of the ribbon.
- Click Query Design.
- Access displays the Show Table dialog.
- Add tblCatchDetails, then close the dialog.
- Add CatchDate to the query grid, then CDte
- Click to highlight Totals in the Show/Hide group of the ribbon.
- This adds a Total row to the query grid. The default is Group By for each column.
- Change the Total option of CDte to Count.
- Switch to Datasheet View to inspect the result.