qry 2 tables in same field

[dan231]

I have an existing qry that is pulling up a student history. I need to modify it so it only shows classes that have been completed.

The catch is that this info is stoed on 2 different tables.
tblClassSchedule, field:Status
tbleStudentHistory, field:EnrollmentStatus

Both fields= "900" if completed.

I have tried to add 2 field qrys, 1 for each table, but I get 33 records, when I should only have 10 fully completed classes.

I am running into issues when I try to put these into the same field.
I need something in the qry to show: when both tblClassSchedule.Status=900 AND tbleStudentHistory.EnrollmentStatus=900

I have experimented with variants of this:
Expr1: tblBaClassSchedule.Status="900" & tblBaStudentHistory.EnrollmentStatus="900"

Any ideas?

 

[Moniker]

How are the two tables joined? If they aren't, there's your problem. You want something like this:

[u]tblBaClassSchedule[/u]    [u]tblBaStudentHistory[/u]
StudentID         --> StudentID
Status                EnrollmentStatus
.                     .  
(other fields)        (other fields)
.                     .

That's a left join between tblBaClassSchedule and tblBaStudentHistory.

 

[dan231]

Closed

They are joind by student number.

I'm not sure what the problem is, but I tracked down another issue and it is an issue that will sove this problem for me. But it is a data issue. I can get all my info from 1 table, but the table is not complete. So that is a problem for data entry.

Thanks for the response, greatly appreciated.