Query by month problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've built a database in Access 2002 (we're using Windows XP) to make my job
easier.

I have had no problems using the "between...and" in running monthly reports
until now. My database is now a year old and I'm getting June 2004
statistics in with my June 2005 statistics. I've tried using "not like" and
<> - in every way I can think of(such as not like 06/**/2004, < 06/30/2004),
but keep getting the 2004 data. It appears the database is reading the
months and not understanding the difference in the years.

Can anyone help? Forget about anything that involves using VBA unless you
spell out PRECISELY what I should do step by step - I can't even get a macro
to work let alone Visual Basic.
 
That was one variation I had not tried. Unfortunately, it yielded NO results
at all. I tried changing the #s to "s and was back at square one - getting
June 2004 and June 2005 data.

Thanks anyway.
 
What data type are you using to store the date? If it's a Date/Time field,
then what Lynn suggested should work.
 
Doug -

Thanks for the post. I was positive I had set all my date fields as
Date/Time, but in double-checking after seeing your post, I found they're all
Date/Time EXCEPT the one I need in this situation - it was inadvertantly set
as TEXT. I'll fix that - it sounds like it will help a lot.

Thanks again.

Ruth
 
Back
Top