I have a field called coll_follupdate and when i run my query i want to be able to select all the date ranges for ex. 5/01/08 - 7/09/08. But when i run my query all i get is all the accounts with the date of 5/01/08 - 7/09/08 and nothing in between.

in my query in the criteria for the field i have

[Enter a start date]
[Enter end date]

any help thanks

On different lines? You want this on one line:

Between [Enter a start date] And [Enter end date]

ive tried that but it gives me all records, just not the ones within my search

any more help?

Can you post a sample db? Is your field actually a date field? Between is commonly used to restrict records to those that fall between the 2 parameters, inclusive.