Repeated Date

[Yecenia]

I have a Query that has a column with dates. Some of the dates are repeated.

I need to see all folks that show repeated dates. I set the query to show
the dates and the count of dates. I put the criteria under the count of
dates as ">2". But I get an error. What is the correct way of pulling
information that shows duplicate dates.

Help!

 

[Michel Walsh]

Should be fine (without double quotes), but still preferable to use >=2
rather than just >2, isn't it? Do you really have a TOTAL query, or you
just used COUNT in a computed expression?

In the latter case, that may explain why you get an error. Be sure to start
with a total query. With Access 2003, you click on the Summation button, on
the toolbar (the one with a kind of M rotated by 90 degree) to get an extra
line, TOTAL, in the design grid. Then bring the required fields in the
grid. I assume you will need the 'folk' and the 'date time stamp' field.
Keep the proposed GROUP. Next, bring a field which won't be null (folk can
be fine), and, under this third column, change the GROUP to COUNT. Still
under that column, as criteria, use >=2


Vanderghast, Access MVP

 

[John W. Vinson]

I need to see all folks that show repeated dates. I set the query to show
the dates and the count of dates. I put the criteria under the count of
dates as ">2". But I get an error. What is the correct way of pulling
information that shows duplicate dates.

Please post the SQL of your query and the error message.