L
Lori''s Little Secret
I want to create an expression that charges 10% freight on the retail with a
9.50 minimum. How do I do that?
9.50 minimum. How do I do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
If you had someone working for you who didn't "get it", how would you
explain to that person what you wanted done?
Remember, they don't know/understand anything about your business, so you'll
need to explain the details about what you take for granted...
For example, are you describing a situation in which a customer might have
several items in an order? Will your worker need to add all those "retail"
amounts up before applying your "freight charges"?
If every "order" gets charged 9.50 (or more), one way you could describe
that expression would be:
The maximum of 9.50 or 10%(????!).
If you'll provide more specific descriptions, folks here may be able to
offer more specific suggestions...
Regards
Jeff Boyce
Microsoft Office/Access MVP
explain to that person what you wanted done?
Remember, they don't know/understand anything about your business, so you'll
need to explain the details about what you take for granted...
For example, are you describing a situation in which a customer might have
several items in an order? Will your worker need to add all those "retail"
amounts up before applying your "freight charges"?
If every "order" gets charged 9.50 (or more), one way you could describe
that expression would be:
The maximum of 9.50 or 10%(????!).
If you'll provide more specific descriptions, folks here may be able to
offer more specific suggestions...
Regards
Jeff Boyce
Microsoft Office/Access MVP
L
Lori''s Little Secret
Yes all of the products get added up into a retail subtotal. Shipping is 10%
of that retail. The minimum amount for the shipping is 9.50. So shipping on
a 0-95 dollar order would be 9.50 and then it would be 10% of the
aforementioned retail. So shipping on a 250.00 order would be 25.00. Does
this help?
of that retail. The minimum amount for the shipping is 9.50. So shipping on
a 0-95 dollar order would be 9.50 and then it would be 10% of the
aforementioned retail. So shipping on a 250.00 order would be 25.00. Does
this help?
J
Jeff Boyce
You don't mention where you are trying to do this, but you posted in a
"forms" group. Are you trying to do this on a form?
Does your form already have a way to "subtotal" the "retail". Does "retail"
mean your form could have items that are not "retail"?
I'm still not sure I have enough information to offer specific suggestions.
You can put an expression in the Control Source of a control on your form.
Consider looking in Access HELP for the IIF() function -- I believe you
could use that to create your expression. Check back to my previous
response for an approach ... default of 9.50, unless the 10% is higher.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"forms" group. Are you trying to do this on a form?
Does your form already have a way to "subtotal" the "retail". Does "retail"
mean your form could have items that are not "retail"?
I'm still not sure I have enough information to offer specific suggestions.
You can put an expression in the Control Source of a control on your form.
Consider looking in Access HELP for the IIF() function -- I believe you
could use that to create your expression. Check back to my previous
response for an approach ... default of 9.50, unless the 10% is higher.
Regards
Jeff Boyce
Microsoft Office/Access MVP