Parameters in queries

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

how can I write a query that specifies the value of a parameter that
exists in a subquery.

eg

SELECT field FROM qrySUB
WHERE ....

qrySUB:

SELECT field where fldDate = [addDate]

Basically the reason I want to do this is that I want two similar
queries one that specifically uses todays date and the other where you
can choose the date and I dont want to duplicate all my subqueries for
each.
.

Quantcast