sub query refrence field in main query

  • Thread starter Thread starter inungh
  • Start date Start date
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,
 
Back
Top