Parameter input box not appearing

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Your problem appears to be --
WHERE (((Findings.[Finding Status]) Like "*" & [Finding Status] & "*"))

I assume your second [Finding Status] is supposed to be your prompt. For it
to prompt you it must be different from the field name. Being the same as
the field name it just compares the field with the field.
 
Karl - Doh! That was the problem. I usually dont put spaces in my field
names but one snuck in on me. Thanks for noticing that.

John

KARL DEWEY said:
Your problem appears to be --
WHERE (((Findings.[Finding Status]) Like "*" & [Finding Status] & "*"))

I assume your second [Finding Status] is supposed to be your prompt. For it
to prompt you it must be different from the field name. Being the same as
the field name it just compares the field with the field.

John said:
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
Click to expand...
Click to expand...
 
Back
Top