Access 2000 Query Criteria

  Mr A! 14:27 12 Nov 2004
Locked

I have a query with a number of field of which one being "OrderDate". I want the query to find all orders placed from the 1st of the month to the day the query is run. Can anyone help?

  recap 15:11 12 Nov 2004

Try the following:

Year[OrderDate]=Year(Now)) And Month([OrderDate])=Month(Now())

This should then show only the records entered during the current month.

  Mr A! 17:25 12 Nov 2004

it didn't work. I figured out youleft a ( out at the beginning but when i included it it still didn't work.

Also, does anyone know how to log all activities done on my database (records added, edited, times dates etc). I have a login system which records logins and logouts?

  AccessMoron 22:11 15 Nov 2004

Try

WHERE (((DatePart("m",[OrderDate]))=DatePart("m",Date())) AND ((DatePart("yyyy",[OrderDate]))=DatePart("yyyy",Date())))

In SQL

  recap 09:36 18 Nov 2004

Sorry I have taken so long in replying Mr A!

Have you tried the "Between" criteria formula:

Between [enter start date:] And [Enter Last Date:]

  mark3110 10:52 18 Nov 2004

start date
>=#18/11/2004#

It will then show results up til the current date.

= being equal to the start date
> showing dates greater than the start date

Think you should be able to work it out now :D

Mark

  Mr A! 21:47 22 Nov 2004

thanks very much guys.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?