asked on
Creating a parameter query in Access that prompts for dates?
Hi Folks
Just wondering how I would create a parameter query in Access that prompts for a month rather than a specific string? Thanks.
Just wondering how I would create a parameter query in Access that prompts for a month rather than a specific string? Thanks.
Microsoft OfficeMicrosoft Access
Last Comment
agwalsh
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
hm, I've shown them how to do the form thingy but one of the people I was working with had seen it in a query (date dropdown) and wanted to know how to do it...but will try out your suggestions...thank you :-)
FWIW - Users really should not be interacting directly with queries (or tables), simply because there is a great risk of data destruction or modification.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Had to go a different route but this was helpful :-)