sub query refrence field in main query

I

inungh

I have a query with sub query and get an error message that sub query
returns more than one record.

It seems that my query reference miand field query is not on current
record, but the whole table.

I would like to calculate student results have different weight factor
depends on the class of students.

My sub query referes Student ID in the student table to get weight
factor on the weight factor table. It seems the sub query returns al
the weight factor, but not the weight factor for that class.

Are there any example to refer a field of the main query at same
record for sub query?


Your information is great appreciated,
 

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

Access Append Query Failure 1
In query records returned multiple times 6
An Unmatched Query? 2
using Dates as a Criteria/Lookup in Query 2
Exicute an append query in an after update event 0
Update Query using Table & Query 3
date query in the sub-report 1
Improving append query speed 1

Top