Expressions with a minimum

[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?

[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

"Lori''s Little Secret" <LorisLit...@discussions.microsoft.com> wrote
in message news:6B4C34D1-C2BB-4858...@microsoft.com...

[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?

[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

"Lori''s Little Secret" <LorisLit...@discussions.microsoft.com> wrote

in message news:2826B5A6-31AD-47A1...@microsoft.com...

[Linq Adams via AccessMonster.com]

I can't test this now, but your expression needs to be something like:

IIf([SubTotal] * 0.1 > 9.5, [SubTotal] + ([SubTotal] * 0.1), [SubTotal] + 9.5)

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com