greensleeves149
Member
- Local time
- Today, 12:30
- Joined
- Feb 27, 2022
- Messages
- 49
Hello everyone,
I haven't really used Access much in over 10 years. I used to use some of it's basic functionality (minus programming) for years. But now I'm super rusty and have been mulling over this for over 2 days and still blank, so thought I might ask for some input please.
So it's clearer, I thought I would attach a snippet of the table.
I'm wanting to return the applicable ' Base Price' based on
1) the selected 'Product Type' (either Standard or Non Standard AND
2) SizeTier (Small or Large) AND
3) Weight AND
4) Length AND
5) Width AND
6) Depth
Right now I've split the Weight and dimensions into Max and Min- I could change that if necessary. I did that thinking about a big IIF statement at the back of my mind!
This query will form part of a form where I'm wanting a user to enter to select the Product Type, SizeTier and then enter the weight and dimensions and have the form pick and return the respective price for that item.
For example, let's say I selected 'Standard', 'Large' and entered '14' for weight, '17' for length, '14' width and '7' for depth, I want the form to show $4.52 in the price field.
I know the query will need to refer to some of the form attributes (Product Type, SizeTier, weight and dimensions), but I have to admit that besides referencing the form where applicable, I'm blank in remembering how to actually query the rest so that it returns the respective Price.
Can someone please enlighten me?
Thank you
I haven't really used Access much in over 10 years. I used to use some of it's basic functionality (minus programming) for years. But now I'm super rusty and have been mulling over this for over 2 days and still blank, so thought I might ask for some input please.
So it's clearer, I thought I would attach a snippet of the table.
I'm wanting to return the applicable ' Base Price' based on
1) the selected 'Product Type' (either Standard or Non Standard AND
2) SizeTier (Small or Large) AND
3) Weight AND
4) Length AND
5) Width AND
6) Depth
Right now I've split the Weight and dimensions into Max and Min- I could change that if necessary. I did that thinking about a big IIF statement at the back of my mind!
This query will form part of a form where I'm wanting a user to enter to select the Product Type, SizeTier and then enter the weight and dimensions and have the form pick and return the respective price for that item.
For example, let's say I selected 'Standard', 'Large' and entered '14' for weight, '17' for length, '14' width and '7' for depth, I want the form to show $4.52 in the price field.
I know the query will need to refer to some of the form attributes (Product Type, SizeTier, weight and dimensions), but I have to admit that besides referencing the form where applicable, I'm blank in remembering how to actually query the rest so that it returns the respective Price.
Can someone please enlighten me?
Thank you