3. In the Query Parameters window (see B), on the first line in the Parameter field [ YourFieldName ] and in the Data Type select the one that applies to your fields data type from the drop down.  Continue till done.

4. Close, save and run your Query
In SQL View your PARAMETER will always show at the top...

PARAMETERS aAssociateID Long;
SELECT tblActivities.aDate, tblProjects.pDueDate, tblActivities.aKeyword, tblActivities.aAssociateID, tblActivities.aCustomerID, tblActivities.aProjectID, tblActivities.aActivityID, tblActivities.aNotes, tblActivities.aActivityCompleted, tblActivities.aDateModified, tblActivities.aDateCreated
FROM tblProjects RIGHT JOIN tblActivities ON tblProjects.pProjectID = tblActivities.aProjectID
WHERE (((tblActivities.aDate) Between DateValue(Date()-Weekday(Date(),1)+1) And DateValue(Date()-Weekday(Date(),1)+7) Or (tblActivities.aDate) Is Null) AND ((tblActivities.aAssociateID)=[Enter Associate ID]) AND ((tblActivities.aActivityID)>100) AND ((tblActivities.aActivityCompleted)=0)) OR (((tblProjects.pDueDate) Between DateValue(Date()-Weekday(Date(),1)+1) And DateValue(Date()-Weekday(Date(),1)+7)) AND ((tblActivities.aActivityID)>100) AND ((tblActivities.aActivityCompleted)=0))
ORDER BY tblActivities.aKeyword;
Using Parameters in a Crosstab Query...

1. Open Query in Design View
2. On the Menu Bar go to Query then Parameters (see A)
The difficult I do immediately, the impossible takes a little bit longer.
Tips (Main)
Action Query Errors
OrderBy OR Order By
Memo field is truncated when exported to Excel
Query Joins
Append and/or Update Data to Table Created Dynamically
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.