Dynamic date in my query

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

Hi, this is a part of my query :

WHERE (((TEMPS.DATE)>#03/1/2004#));

Now, I d like to put dynamically the current month in my query.. how to do
this ?
WHERE (((TEMPS.DATE)>#Month(Now())/1/2004#));
desoent wor kat all..
 
Fred

You didn't mention whether this was a query being built in design mode, or
via an SQL statement.

If your objective is to compare with the first of the current month, you
could use the DateSerial() function as a criterion. For example, your
criterion "cell" in the query designer could hold something like:
 

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

Similar Threads

Make Table Dynamic Table Name using INTO 2
Use In() Expression as Query criteria with guts from Function 1
Formula in Access Query to genrate numbers 1
Totalling Rows and Columns in a Crosstab Query 1
dynamic calculated field in query 3
Crosstab Column Heading Sort 3
Crosstab Query Issue 1
Modifying my Date Select Query 2

Back
Top