Query to show accounts which appear everyday for 14 days.

[fastpants]

Hello

I have a series of information showing the results of our in house dialler and an access database. I need to run a query to see which accounts have shown up everyday in the last 14 days. I am just using Access as there are over 4 million records and i dont want to over complicate things.

Imagine the database has 3 fields, 'date', 'account number' and 'result of dial'.

I have got the date bit which i have put in a as a prompt which is
>=[enter start date]

Thats no problem, but how do i get it to pull up accounts which have only appeard on each day? i.e all account which we have dialled on for 2 weeks without a succesful result.

I'm sorry if i am waffling a bit i want to ensure all the info is here.

Thanks
FP

 

[NumbersMax]

Conceptually, you could Count the number of times the account appears and compare that to a DateDiff() function where you get the difference between the start date and today.

Have the Count of the account number = the Datediff (days between start date and today) in the criteria

This could be a little tricky on a query grid trying to get it just right in the criteria, but maybe the VBA gurus can offer up a more elegant solution.

Max

 

[fastpants]

Thats great.

I will give it a whirl.

Thanks again.