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

Top