Parameter Query

[EndersG]

Is there a way you can place a default value in the box of a parameter query (i.e., current date for a date parameter)? Similar to what you can do with an InputBox.

 

[Fornatian]

I believe you could use a function suchas:

Nz([YourField],Date())

 

[raskew]

Give the following query a try in Northwind. When prompted to enter a date:
(1) enter 12/1/94 -- the query will return records with that OrderDate only.
(2) Click OK without specifying a date -- the query will return records with OrderDate #3/15/95#, the default date specified in the query SQL.

SELECT Orders.OrderID, Orders.EmployeeID, Orders.OrderDate
FROM Orders
WHERE (((Orders.OrderDate)=#3/15/1995#) AND
(([enter date]) Is Null)) OR (((Orders.OrderDate)=[enter date]) AND 
(Not ([enter date]) Is Null));

 

[EndersG]

Default value for parameter query

raskew,

You are a life-saver!!!!

 

[EndersG]

Parameter default values

Although I tried Ian's and his solution is more streamlined. Touche Fornatian!