Parameters question

[Dave]

Hi,
Can someone please explain the requirement/advantage of declaring parameters
in a query? For example, these two queries return the same results, so why
declare the parameters?

PARAMETERS [Enter Date] DateTime;
SELECT Orders.CustomerID, Orders.OrderDate, Orders.ShippedDate
FROM Orders
WHERE (((Orders.OrderDate)>[Enter Date]));


SELECT Orders.CustomerID, Orders.OrderDate, Orders.ShippedDate
FROM Orders
WHERE (((Orders.OrderDate)>[Enter Date]));

Thanks for any insight,
Dave

 

[Duane Hookom]

Parameters are generally required for dynamic criteria in crosstab queries
(not always). Otherwise, they are mostly ignored in other queries. They
might increase the performance a little but don't quote me on that.