Query calculation

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'm sorry, I did not understand it.
 

Users who are viewing this thread

Back
Top Bottom