Passing paramerters inside queries

P

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

Similar Threads

Query Parameter using multiple options 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Parameters with IN clause. 3
Access Access Queries 0
Aggregate Function Error 0
Query not picking up form values 1
Report Query Works 2nd Time, But Not 1st 14
how to pass a parameter to a query base of a query that is the base of a report 0

Top