ok this is what I'm typing for my value in the query

=#2005/10/25 7:00:00 AM# And <=#2005/10/26 8:00:00 AM#

This is what Access changes it to automaticlly

=#2005/10/25 7:00:00 AM# And <=#2005/10/26 8:00:00 AM#

This was a code I got from a helping hand.

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

The plan is to have the [Enter a start date] referance a cell, same goes for
the [end date]. Presently I have cells B1 and B2 with the start and end
date. But no matter which way I try to enter in the dates I keep getting
errors on matches to format string or an error about invalid month. I've
checked my Date formats everywhere I can think of and have changed them all
to yyyy-mm-dd hh:mm:ss AM/PM. Any help would be most kind.