Date format in Query

L

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.
 
T

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top