Combine 3 tables

M

Michelle

I have a query that has the following code...

SELECT inmtinfo.IN_CELLDRM, inmtinfo.IN_INMNUM, inmtinfo.IN_NAME,
inmtinfo.IN_BLDING, inmtinfo.IN_SECTION, tblInspection.DATE,
tblInspection.TIME, tblInspection.BARS, tblInspection.W_S,
tblInspection.A_VENTS, tblInspection.W_C_F, tblInspection.PF_C,
tblInspection.EF_C, tblInspection.CF, tblInspection.D_F_W_L,
tblInspection.B_M_F, tblInspection.STAFF, tblInspection.Comment
FROM inmtinfo LEFT JOIN tblInspection ON
inmtinfo.IN_INMNUM=tblInspection.IN_INMNUM
WHERE (((inmtinfo.IN_BLDING)="H") AND ((inmtinfo.IN_SECTION)=[ENTER POD]));


It joins two tables for use in a form. What I now need it a button on the
form that pops up a box called Comments, this I can get to work. The problem
is I am not sure how to add the comments to the report that is created by
this form.

The comments table would need to be related to the above query based on I
would say date and pod.
 

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

Similar Threads

Can this be done... 6
Error "The search key was not found in any record" 1
Union Query Problem 4
Delete Query Problem 1
Union Query Issue 1
Left Join 2
Union issue 1
Not sure if this can be done in access 1

Top