Month Query

Hi,

I read many posts on the accessmonster site regarding month queries, but
still can't find a best solution for my database. Here is my situation, I
have Main table, with different department queries. On the Department field,
Criteria "Department Name." I also have a field called Scheduled Month. It
is in Month name from january - december. i want users to be able to pull up
reports with from Month___ to Month____ . i tried putting criteria as,
Between [Enter Starting Month] and [Ending Month] in the Scheduled Month
field. But it doesn't work. Sometimes it gives me just january, and
sometimes nothing. Anybody has any suggestions for me to make this more user-
friendly and easy to look up? I read many of Month queries, and seems like
the number months work much better than text? If i want to change to number
month, how do i start?


Thanks you!

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: Question on conversion to ADP
    ... the money toward developping .NET technologies instead of Access. ... result of passthrough queries read/write instead of read only and also make ... database become corrupted when the users will start making their very own ... of ADP but what they are pushed toward is - how could I say that politely - ...
    (microsoft.public.access.adp.sqlserver)
  • Re: User has group permissions to object, but still denied access.
    ... permissions to those query objects. ... The owners for the other 68 queries can be changed. ... may have been some of the original queries created in the database. ... Regarding the security, the database was converted from an Access 97 ...
    (microsoft.public.access.security)
  • Re: Access/Word 2007 Mail Merge
    ... have thought that they would have occured earlier in the connection process. ... specify DDE, I always get the DDE dialog. ... might be "unusual" about your database, its location, etc. ... This isn't quite what I normally see either: Queries with joins are ...
    (microsoft.public.word.mailmerge.fields)