User input of a Where parameter,, how?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to alter the following query:
SELECT dbo_Requests.Req_Date, dbo_Requests.Version, dbo_Requests.File_Name,
dbo_Requests.Company_Name, dbo_Requests.Contact_Name, dbo_Requests.Country,
dbo_Requests.Phone, dbo_Requests.Email_Address
FROM dbo_Requests
WHERE Req_Date>DateAdd("d",-3,Date())
ORDER BY dbo_Requests.Req_Date DESC;


So that I can all the User in input the number of days from the current
date the report should cover
WHERE Req_Date>DateAdd("d",-3,Date()) The Parameter that needs to be able
to change is -3.

I want the user to open up and the only thing they see is the input request
for the number of days the report should cover and then an option to quit or
print the report. Maybe an option to export to excel, haven't decided.
 
Back
Top