By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Using criteria in multiple fields in a query

P: 2
Hi,
I am a total novice at access. I have a table which has fields such as rep, client, work, week 1, week 2, week 3, week 4 etc. In the week fields I put in dates. i.e week 1 is the first week in teh month, 2 is second week and so on. I want to create a query that will give me the option of selecting the rep, client, work and week that the work was done. i.e a parameter which gives me the option of entering a date in week 1 or a date in week 2 or a date in week 3. I can get it to work when I select rep x for week 1, but when I select rep x and don't enter a date in week 1 and move on to week 2 and enter my date, I end up with all the reps selected for that particular date. How can I enter my parameters to give me the option of the dates.? I hope this makes some kind of sense to somebody.
Thanks
Jul 18 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi,
I am a total novice at access. I have a table which has fields such as rep, client, work, week 1, week 2, week 3, week 4 etc. In the week fields I put in dates. i.e week 1 is the first week in teh month, 2 is second week and so on. I want to create a query that will give me the option of selecting the rep, client, work and week that the work was done. i.e a parameter which gives me the option of entering a date in week 1 or a date in week 2 or a date in week 3. I can get it to work when I select rep x for week 1, but when I select rep x and don't enter a date in week 1 and move on to week 2 and enter my date, I end up with all the reps selected for that particular date. How can I enter my parameters to give me the option of the dates.? I hope this makes some kind of sense to somebody.
Thanks
I think you need to restructure how you are recording the weeks. Have a look at this tutorial.

Database normalisation and table structures.
Jul 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.