marthacasting
Registered User.
- Local time
- Today, 08:29
- Joined
- Oct 17, 2011
- Messages
- 67
First let me say that I am a novice Access user.
I am trying to set up a query so I can create a report for the people who will be in our back room sending equipment to different camps.
We ask the campers to answer an online questionnaire that includes their shoe size and pant sizes (S, M, L, XL, XXL, XXXL). That info is then imported into Access.
However, it's not as simple as that. For those campers who wear a size S,M,L, or XL pant, we automatically increase their boots by one size from what they told us. For those who wear XXL or XXXL pants, we need to increase their boots by two sizes.
How can I set up a query to automatically make these adjustments in shoe sizes based on the pant sizes?
THANK YOU!!
I am trying to set up a query so I can create a report for the people who will be in our back room sending equipment to different camps.
We ask the campers to answer an online questionnaire that includes their shoe size and pant sizes (S, M, L, XL, XXL, XXXL). That info is then imported into Access.
However, it's not as simple as that. For those campers who wear a size S,M,L, or XL pant, we automatically increase their boots by one size from what they told us. For those who wear XXL or XXXL pants, we need to increase their boots by two sizes.
How can I set up a query to automatically make these adjustments in shoe sizes based on the pant sizes?
THANK YOU!!