Help with parameter query that prompt users for input
Hi All,
I have a Form that is used to print a report and the report is based off of a query.
I don’t like the WHERE statement in the query. I want the user to enter the employer codes and not have to continue to press enter when they are done entering 5 employer codes.
Example: The want to send letters to 3 Employer codes but after they enter the 3rd employer code the query will continue asking for 21 more employer codes. How can I provide the user a way to not be asked for 21 more employer codes?
I guess what I'm trying to do is create prompts for report criteria.
Thank you,
Rich
The current code for the query is:
Hi All,
I have a Form that is used to print a report and the report is based off of a query.
I don’t like the WHERE statement in the query. I want the user to enter the employer codes and not have to continue to press enter when they are done entering 5 employer codes.
Example: The want to send letters to 3 Employer codes but after they enter the 3rd employer code the query will continue asking for 21 more employer codes. How can I provide the user a way to not be asked for 21 more employer codes?
I guess what I'm trying to do is create prompts for report criteria.
Thank you,
Rich
The current code for the query is:
Code:
SELECT Format([Enter Letter Date],"mmmm dd"", ""yyyy") AS [Letter Date], dbo_partfile.prt_employer_code, dbo_employer.mis_description, UCase([kn_key_name]) AS UID, Trim([prt_last]) AS [LAST], Trim([prt_first]) AS [First], dbo_partfile.prt_middle, dbo_partfile.prt_addr1, dbo_partfile.prt_addr2, Trim([prt_city]) AS City, dbo_partfile.prt_state, dbo_partfile.prt_zip_code, Format([prt_zip_ext],"0000") AS Zip4, Format([Enter Term Date],"mmmm dd"", ""yyyy") AS [Term Date], IIf([prt_sex]="F","Ms.","Mr.") AS Title, dbo_partfile.prt_status, dbo_partfile.prt_local_nbr
FROM dbo_keyname_u INNER JOIN (dbo_partfile INNER JOIN dbo_employer ON dbo_partfile.prt_employer_code = dbo_employer.mis_number) ON dbo_keyname_u.kn_number = dbo_partfile.prt_ss_nbr
WHERE (((dbo_partfile.prt_employer_code)=[Enter center number 01] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 02] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 02] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 03] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 04] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 05] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 06] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 07] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 08] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 09] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 10] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 11] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 12] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 13] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 14] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 15] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 16] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 17] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 18] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 19] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 20] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 21] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 22] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 23] Or (dbo_partfile.prt_employer_code)=[If needed enter center number 24]) AND ((dbo_partfile.prt_status)="A") AND ((dbo_partfile.prt_local_nbr)=205))
ORDER BY dbo_partfile.prt_employer_code, Trim([prt_last]);
Last edited: