|
Regina Whipp |
|
The difficult I do immediately, the impossible takes a little bit longer. |
Using parameters in a Crosstab query |
|
Queries |
|
1. Open query in Design View 2. On the Menu Bar go to Query... Parameters… |
|
3. On the first line type in the Parameter field [YourFieldName] and in the Data Type select a Data Type from the drop down 4. On the second line type in the Parameter field [YourFieldName] and in the Data Type select a Data Type from the drop down 5. Continue until done 6. Run your query… 7. Don’t forget to Save 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; |