Form Calculation

  • Thread starter Thread starter Sureshkumar via AccessMonster.com
  • Start date Start date
S

Sureshkumar via AccessMonster.com

I have four fields viz. Publication (text), Color (text), Base_Rate (number),
Add-on-rate (number)

I want to create a screen wherein a user has to select the publications & the
required color which can be either black & white or 4C.

A user can select as many publications he wants. It can be either in black &
white or 4C. The rate will vary accordingly based on the color selected.

Among the publication selected whichever publication has the highest
base_rate will be taken as it is and the other publications go at the add-on-
rate.

Can anyone help me with this. Please design a form based on the above and
post it. I desperately seek a help.

Thanks & Regards
Suresh

--
K. Suresh
email: (e-mail address removed)
(e-mail address removed)

Message posted via AccessMonster.com
 
This news group is for helping others and sharing information. It is not a
place to get free work done for you.
 
Thanks...I asked for help, not asking for any free work. If possible help
else ignore.

This news group is for helping others and sharing information. It is not a
place to get free work done for you.
I have four fields viz. Publication (text), Color (text), Base_Rate (number),
Add-on-rate (number)
Click to expand...
[quoted text clipped - 14 lines]
Thanks & Regards
Suresh
Click to expand...
Click to expand...

--
K. Suresh
email: (e-mail address removed)
(e-mail address removed)

Message posted via AccessMonster.com
 
It would just need a sub on the form. It would be called in the after
update event of each of your four input controls and the last step of it
would be to set another control (txtQuote for example) to whatever your code
comes up with. It would just be something like a complicated version of
this:

sub SetQuote()
dim quote as whatever
select case me.color
case "Red","Blue"
quote=1
case "Green"
quote=2
case else
quote=3
end select
quote=quote*me.baserate
me.txtQuote=quote
end sub

....the real logic is obviously up to you.
 
Back
Top