Date format in Query

[Lovespar]

I have a table collecting data in the typical date/time format. The format of
the date is listed as Short date but still the time is displayed on the
table.
I am trying to get this date to align with dates in other queries so that I
can display two fields Grind and Production by date. If I use this in the
date field criteria
(Format([Wkly Grind.Date],"Short Date")), I get only a select number of
fields that are formatted as Short date in the table. (Apparently there was a
change of some kind so in my table of 2000 records only 20 are actually Short
Date). I want to actually change the format of all the data so that I can use
this formula to select for dates.
Between #7/26/2009# And #8/3/2009#
Thanks
Any Help would be appreciated.

 

[terry stein]

hi every one
my wairless microphone often makes a lot of noise,i don't the
reason.anyone who know the answer please email me.
so many thanks!