G
Guest
I've built a query based on multiple tables. Unfortunately, when I run it,
it does not ask for user input for the parameters. Instead, it returns all
records.
Overall table structure looks like this (from parents to children.)
AUDITS Table->FINDINGS Table->MCA Table->CAPR Table
The query parameter is based on Finding Status.
The current SQL:
SELECT Audits.OfficialAuditNumber, Audits.AuditTitle,
Audits.AuditDescription, Audits.AuditDate, Audits.AuditOrg, Audits.Auditor,
Audits.AuditStatus, Findings.OfficialFindingNumber, Findings.FindingDesc,
Findings.RiskRating, Findings.InitialDetermination, Findings.[Finding
Status], MCA.OfficialMCANumber, MCA.RespDir, MCA.RespDept, MCA.RespDiv,
MCA.RespGroup, MCA.RespPerson, MCA.DueDate, MCA.MCAStatus, CAPR.CAPR,
CAPR.CAPRDate
FROM ((Audits LEFT JOIN Findings ON Audits.SysGenAuditNumber =
Findings.AuditNumber) LEFT JOIN MCA ON Findings.SysGenFindingNumber =
MCA.FindingNumber) LEFT JOIN CAPR ON MCA.SysGenMCANumber = CAPR.MCANumber
WHERE (((Findings.[Finding Status]) Like "*" & [Finding Status] & "*"))
ORDER BY Audits.OfficialAuditNumber, Findings.OfficialFindingNumber,
MCA.OfficialMCANumber, CAPR.CAPRDate DESC;
Should I adjust the join function?
Thanks,
John
it does not ask for user input for the parameters. Instead, it returns all
records.
Overall table structure looks like this (from parents to children.)
AUDITS Table->FINDINGS Table->MCA Table->CAPR Table
The query parameter is based on Finding Status.
The current SQL:
SELECT Audits.OfficialAuditNumber, Audits.AuditTitle,
Audits.AuditDescription, Audits.AuditDate, Audits.AuditOrg, Audits.Auditor,
Audits.AuditStatus, Findings.OfficialFindingNumber, Findings.FindingDesc,
Findings.RiskRating, Findings.InitialDetermination, Findings.[Finding
Status], MCA.OfficialMCANumber, MCA.RespDir, MCA.RespDept, MCA.RespDiv,
MCA.RespGroup, MCA.RespPerson, MCA.DueDate, MCA.MCAStatus, CAPR.CAPR,
CAPR.CAPRDate
FROM ((Audits LEFT JOIN Findings ON Audits.SysGenAuditNumber =
Findings.AuditNumber) LEFT JOIN MCA ON Findings.SysGenFindingNumber =
MCA.FindingNumber) LEFT JOIN CAPR ON MCA.SysGenMCANumber = CAPR.MCANumber
WHERE (((Findings.[Finding Status]) Like "*" & [Finding Status] & "*"))
ORDER BY Audits.OfficialAuditNumber, Findings.OfficialFindingNumber,
MCA.OfficialMCANumber, CAPR.CAPRDate DESC;
Should I adjust the join function?
Thanks,
John