filtering date

  • Thread starter Thread starter Emir
  • Start date Start date
E

Emir

I am a bit new in ms access. Can you help me create a code so I can filter a
particular date of the database "from this date" - "to this date" method
avoiding the use of parameters. Actually, what I just want to do is to filter
a particular MONTH.
 
The answer may be different depending on where you want to do this filtering.
Can you be more explicite, please.
 
Hi -

In a query:

Between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),
Month(Date())+1,0)

in the criteria cell of your date field will return records for the current
month.

HTH - Bob
 
Hi,
Though it seems that only the current date is being filtered (or maybe I
missed something), it gives me some idea. Thanks a lot
 
Hi Klatuu,
I will try to be more explicit this time though I am telling you I am new in
ms access. Here it is: In a form I would like to input a date for "from this
date" unbound text box and input again a date for "up to this date" unbound
text box so when I push a button I created in the same form a report will be
generated (preview or print) filtering the dates of the data from a given
date to a given date.
 
Back
Top