Lookup

[Richard]

I have a main table called Reports. In it I have a Staff PIN and a
Supervisior PIN. I have another table that has all the PINs and employees
scanned signatures. On the final report, I need both the Staff and Supervisor
Signatures to display. I can get one signature to show up, but noth both. I
would appreciate your help in finishing this piece. Much thanks

 

[KARL DEWEY]

Are we to guess as to how you got the one to show?

 

[Richard]

Originally I only had the Supervisor signature to worry about. Now I need to
add the staff signature. That's when things got tricky. So, I'm trying to
setup a look up in the report query like this Staff_Sig:
DLookUp([SIGNATURE],"tblSigs",[PIN]=[Reports].[Staff_PIN])

But it's creating an error.

 

[KARL DEWEY]

Post your report query SQL.
--
KARL DEWEY
Build a little - Test a little

Originally I only had the Supervisor signature to worry about. Now I need to
add the staff signature. That's when things got tricky. So, I'm trying to
setup a look up in the report query like this Staff_Sig:
DLookUp([SIGNATURE],"tblSigs",[PIN]=[Reports].[Staff_PIN])

But it's creating an error.

Are we to guess as to how you got the one to show?