The difficult I do immediately, the impossible takes a little bit longer.

1. Open Query in Design View...

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

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;
2. On the Menu Bar go to Query then Parameters ( see A)...
Using Parameters in a Crosstab Query...
Queries
In SQL View your PARAMETER will always show at the top...
aaaaaaaaaaaaiii