LISTBOX HELP

[Sureshkumar]

Can anyone please help me with this. I do not know how to go about creating
this.

Fields in table: RatesMaster

Publication
Color
Base_Rate
Add-on

Values of Publication: TOIH, TOIM, TOID, ETM
Color: BW and 4C
Base Rate for BW: TOIH = 140, TOIM = 1500, TOID = 850, ETK = 200
Base Rate for 4C: TOIH = 200, TOIM = 2000, TOID = 900, ETK = 300
Add-on Rate for BW: TOIH = 100, TOIM = 1400, TOID = 650, ETK = 120
Add-on Rate for 4C: TOIH = 150, TOIM = 1800, TOID = 800, ETK = 180

I want to create a listbox, wherein a person should be allowed to select
various publication & color.

After the selection is made, the system should calculate the total rate.
Among the options selected the application should take the highest Base rate
among the centres selected as it is and should take the Add-on rate for the
other publications & centre and then display the total.

For e.g. if a person selects Publication TOIH, TOIM, TOID and the color as BW
then the logic is 100 + 1500 + 800 + 180

i.e. among the publications selected TOIM has the highest base value and the
other are lower than that, so the Add-on Rate is added to it.

I hope the above is clear and you are able to understand what I am looking
for.

Can anyone please help me with this. I do not know how to go about creating
this.

Thanks & Regards
Suresh

--
K. Suresh
email: k.******@timesgroup.com
su********@gmail.com

[peter]

Hi Suresh
Im sorry but your table structure dose not make sence to me
1. Sureshkumar
Nov 28, 3:19 am show options

Newsgroups: comp.databases.ms-access
From: "Sureshkumar" <u16142@uwe> - Find messages by this author
Date: Sun, 27 Nov 2005 14:19:14 GMT
Local: Mon, Nov 28 2005 3:19 am
Subject: LISTBOX HELP
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

Can anyone please help me with this. I do not know how to go about
creating
this.
Fields in table: RatesMaster
Publication
Color
Base_Rate
Add-on
Values of Publication: TOIH, TOIM, TOID, ETM
Color: BW and 4C
Base Rate for BW: TOIH = 140, TOIM = 1500, TOID = 850, ETK = 200
Base Rate for 4C: TOIH = 200, TOIM = 2000, TOID = 900, ETK = 300
Add-on Rate for BW: TOIH = 100, TOIM = 1400, TOID = 650, ETK = 120
Add-on Rate for 4C: TOIH = 150, TOIM = 1800, TOID = 800, ETK = 180

Values for publications is ok 4 values
For colours you have 2 values *BW and 4C
then you have difrent values based on the above selected
do you have seperate tables for Color to hold these values
Draw the table on a peace of paper and see if it make sence I think
that you need to think of how the table works

[peter]

what is the centre

[Sureshkumar via AccessMonster.com]

Table Structure

Publication Text
Color Text
Base_Rate Number
Add-on Number

Hope the above helps.

Suresh

Sureshkumar wrote:

Can anyone please help me with this. I do not know how to go about creating
this.

Fields in table: RatesMaster

Publication
Color
Base_Rate
Add-on

Values of Publication: TOIH, TOIM, TOID, ETM
Color: BW and 4C
Base Rate for BW: TOIH = 140, TOIM = 1500, TOID = 850, ETK = 200
Base Rate for 4C: TOIH = 200, TOIM = 2000, TOID = 900, ETK = 300
Add-on Rate for BW: TOIH = 100, TOIM = 1400, TOID = 650, ETK = 120
Add-on Rate for 4C: TOIH = 150, TOIM = 1800, TOID = 800, ETK = 180

I want to create a listbox, wherein a person should be allowed to select
various publication & color.

After the selection is made, the system should calculate the total rate.
Among the options selected the application should take the highest Base rate
among the centres selected as it is and should take the Add-on rate for the
other publications & centre and then display the total.

For e.g. if a person selects Publication TOIH, TOIM, TOID and the color as BW
then the logic is 100 + 1500 + 800 + 180

i.e. among the publications selected TOIM has the highest base value and the
other are lower than that, so the Add-on Rate is added to it.

I hope the above is clear and you are able to understand what I am looking
for.

Can anyone please help me with this. I do not know how to go about creating
this.

Thanks & Regards
Suresh

--
K. Suresh
email: k.******@timesgroup.com
su********@gmail.com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200512/1

[Sureshkumar via AccessMonster.com]

Dear Peter,

I'm sorry I have not written it clearly. Pls read the following so that you
can interpret what I need.

Fields in table: RatesMaster

Publication
Color
Base_Rate
Add-on

Values of Publication: TOIH, TOIM, TOID, ETM
Color: BW and 4C
Base Rate for BW: TOIH = 140, TOIM = 1500, TOID = 850, ETK = 200
Base Rate for 4C: TOIH = 200, TOIM = 2000, TOID = 900, ETK = 300
Add-on Rate for BW: TOIH = 100, TOIM = 1400, TOID = 650, ETK = 120
Add-on Rate for 4C: TOIH = 150, TOIM = 1800, TOID = 800, ETK = 180

I want to create a form, wherein a person should be allowed to select various
publication & color.

After the selection is made, the system should calculate the total rate.

Among the options selected the application should take the highest Base rate
among the publications selected as it is and should take the Add-on rate for
the other publications & centre and then display the total.

For e.g. if a person selects Publication TOIH, TOIM, TOID and the color as BW
then the logic is 100 + 1500 + 800 + 180

i.e. among the publications selected TOIM has the highest base value and the
others are lower, so the Add-on Rate is added to it.

I hope the above is clear and you are able to understand what I am looking
for. In all I will be having sixty publications.

I do not know how to go about creating this. Please Help

Thanks & Regards
Suresh

--
K. Suresh
email: k.******@timesgroup.com
su********@gmail.com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200512/1