Prev: Is this relationship ok
Next: Primary key warning messages
From: Lilliana on 27 May 2010 17:10
Hi,
I'm a bit stuck on part of an assignment. I have to design a database for a
company that is user friendly for beginner Access users. Here is the part
I'm stuck on:
"I would like some sort of automatic update of selling prices. We do
across-the-board selling price changes from time to time - usually increases
in response to increases in materials. For example just last week we
increased all selling prices by 5%. However we would want to choose the
percentage - it would not always be 5%."
I know how to increase prices by a certain percentage within queries (either
Select or Update queries), but how would I make this user friendly? I know I
can put a button on a form to run a query, but I cant seem to figure out how
to get Access to request the parameter so the company could input the
percentage increase. Also not sure on the formula for doing this either.
For example presuming the field is called Cost, so you have
CostIncrease:[Cost]*1.1, this works for 10% but to be user friendly I would
want the company to enter 10% rather than 1.1 in the parameter value box.
Any ideas?
From: Jeff Boyce on 27 May 2010 17:33
You could use that same form, add a textbox, ask the user to indicate the %
in the textbox, then modify your query to use that value, with something
like (untested):

Forms!YourForm!YourTextBox

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Lilliana" <Lilliana(a)discussions.microsoft.com> wrote in message
news:3250E2DD-79FF-4E73-AC49-65BA4A934EE7(a)microsoft.com...
> Hi,
> I'm a bit stuck on part of an assignment. I have to design a database for
> a
> company that is user friendly for beginner Access users. Here is the part
> I'm stuck on:
> "I would like some sort of automatic update of selling prices. We do
> across-the-board selling price changes from time to time - usually
> increases
> in response to increases in materials. For example just last week we
> increased all selling prices by 5%. However we would want to choose the
> percentage - it would not always be 5%."
> I know how to increase prices by a certain percentage within queries
> (either
> Select or Update queries), but how would I make this user friendly? I
> know I
> can put a button on a form to run a query, but I cant seem to figure out
> how
> to get Access to request the parameter so the company could input the
> percentage increase. Also not sure on the formula for doing this either.
> For example presuming the field is called Cost, so you have
> CostIncrease:[Cost]*1.1, this works for 10% but to be user friendly I
> would
> want the company to enter 10% rather than 1.1 in the parameter value box.
> Any ideas?


From: KARL DEWEY on 27 May 2010 17:40
User friendly --
IIF(Left([Enter percent change with minus sign if lowering], 1) ="-",
[Cost] - [Cost] * Abs([Enter percent change with minus sign if
lowering]/100), [Cost] + [Cost] * Abs([Enter percent change with minus sign
if lowering]/100))

--
Build a little, test a little.


"Lilliana" wrote:

> Hi,
> I'm a bit stuck on part of an assignment. I have to design a database for a
> company that is user friendly for beginner Access users. Here is the part
> I'm stuck on:
> "I would like some sort of automatic update of selling prices. We do
> across-the-board selling price changes from time to time - usually increases
> in response to increases in materials. For example just last week we
> increased all selling prices by 5%. However we would want to choose the
> percentage - it would not always be 5%."
> I know how to increase prices by a certain percentage within queries (either
> Select or Update queries), but how would I make this user friendly? I know I
> can put a button on a form to run a query, but I cant seem to figure out how
> to get Access to request the parameter so the company could input the
> percentage increase. Also not sure on the formula for doing this either.
> For example presuming the field is called Cost, so you have
> CostIncrease:[Cost]*1.1, this works for 10% but to be user friendly I would
> want the company to enter 10% rather than 1.1 in the parameter value box.
> Any ideas?
 | 
Pages: 1
Prev: Is this relationship ok
Next: Primary key warning messages