N
nbarnett
Hello all, here's my situation. I have quite a few tables in my
database, but I'm trying to figure out how to get the information I
need out of 2 of them. One contains > 50,000 records, all set with a
primary key of the EmployeeID, these are all records of employee
activity...
The other table I'm concerned with contains a list of letters to the
file, corrective action.
I have created a querry that gives me the information I need from the
first table, but I need to exclude entries where the EmployeeID has a
record in the second table where a Yes/No box named Pending is marked
as true.
In the end, I am assigning the values to a list box. Everything works
beautifully, except with this new requirement of leaving out employees
that are pending, I'm treading water.
The querries I'm using are pretty nasty, inner joined to this and that
with a list of Where, Having and AS statements... I think it would be
too hard to explain what is going on... but if it would be beneficial,
I will post it.
Basically, I'm just looking for advice on where to go with this. I
thought about creating a dao.recordset that contains the entries that I
need from the first table, and somehow subtracting entries from the
recordset that match with entries from the second recordset, and then
finally assigning that modified recordset as the rowsource of a
listbox.
Any help is greatly appreciated!
Nick
database, but I'm trying to figure out how to get the information I
need out of 2 of them. One contains > 50,000 records, all set with a
primary key of the EmployeeID, these are all records of employee
activity...
The other table I'm concerned with contains a list of letters to the
file, corrective action.
I have created a querry that gives me the information I need from the
first table, but I need to exclude entries where the EmployeeID has a
record in the second table where a Yes/No box named Pending is marked
as true.
In the end, I am assigning the values to a list box. Everything works
beautifully, except with this new requirement of leaving out employees
that are pending, I'm treading water.
The querries I'm using are pretty nasty, inner joined to this and that
with a list of Where, Having and AS statements... I think it would be
too hard to explain what is going on... but if it would be beneficial,
I will post it.
Basically, I'm just looking for advice on where to go with this. I
thought about creating a dao.recordset that contains the entries that I
need from the first table, and somehow subtracting entries from the
recordset that match with entries from the second recordset, and then
finally assigning that modified recordset as the rowsource of a
listbox.
Any help is greatly appreciated!
Nick