Unless i'm missing something this seems like a basic query.
1 - create a query using the wizard, based on the table containing the data
2 - open the query in design view
3 - on the tool bar click the sum symbol
4 - an extra row will appear in the query design table, ensure that the card number says "group by"
5 - under the date field sort by assending order
when you open the query in data sheet view you should have all data grouped by card number under the same date so any reoccurrances of the same card number under one date will show what you are looking for.
My database's are that big i dont have time to go though the whole database
looking for this information i want the query to pull this information out and get rid of the rest, with a formula some thing like this
SELECT DateValue([Date Time]) AS myDate,[Card Number], Count([Card Number]) AS num_used_per_day
GROUP BY DateValue([Date Time]), [Card Number]
HAVING (Count([Card Number])>2);
if you then add an expression in design view that is set to count records in card number field and then set the SUM row of the design grid to count and list in decending order with >2 in the where coloumn you will have all card uses greater than two on each date listed.
alternativly you can alter this SQL statement by adding your table names, i have tried it and it does the job on any amount of data.
SELECT <<TABLE NAME>>.date time, <<TABLENAME>>.card number, Count(<<TABLE NAME>>.card number) AS [record count]
GROUP BY <<TABLE NAME>>.date time, <<TABLE NAME>>.card number
HAVING (((Count(<<TABLE NAME>>.card number))>2))
ORDER BY Count(<<TABLE NAME>>.card number) DESC;