Passing paramerters inside queries


Paul Eden

Hi there

I was wondering if anyone could tell me if it is possible to pass a
parameter to a query, from within a query.
The sub query returns a SUM of a grouping of records that is dependant
on an ID. I do not want to have to enter the paramerter for the
subquery as well as the paramerter for the main query, and I don't know
how to use a field from the main query as the paramert for the sub query.

I do appologies if this question is a little akward to read.. have read
it over a couple of times, and this is as clear as I can word it.

Many thanks


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