Hello,
I have two questions on creating queries...
1. I am trying to make a query with a user prompt that will pull all records with the month given. I have tried Datepart('m',[DateOf1032])=[Enter month] and I have tried month([DateOf1032])=[Enter month] in the criteria field of my query. Am I just setting up the syntax wrong or am I completely wrong?
2. I need a query that will look at 3 different date fields and see if any of them match the month entered into the user prompt. I am not even sure how to begin this one.
Thanks,
Will