Forum Discussion
Multi table query
Hello, I have created a logbook to record closed and pended issues in the departments and created different tables for each department. I want to know all the pending issues from all the departments...
You perform tasks like this with queries. Parameterized queries, to be precise.
In this case, since we can't see anything in the screen shot called "departments" my best guess for this query in this case would include something like this:
SELECT ID, [RFI NO], RECEIVED, TARGET, RESPONDED, STATUS, COMMENTS, [CCBA RESPO]
FROM [RFI/AD3/CIVIL]
WHERE STATUS = "PENDING"
On a related note, your table and field names reflect some less than desirable naming choices. We try NOT to incorporate spaces and non-standard characters like the / in names. They can, and often do, create complications. It's better to avoid them.
In this case, since we can't see anything in the screen shot called "departments" my best guess for this query in this case would include something like this:
SELECT ID, [RFI NO], RECEIVED, TARGET, RESPONDED, STATUS, COMMENTS, [CCBA RESPO]
FROM [RFI/AD3/CIVIL]
WHERE STATUS = "PENDING"
On a related note, your table and field names reflect some less than desirable naming choices. We try NOT to incorporate spaces and non-standard characters like the / in names. They can, and often do, create complications. It's better to avoid them.