By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

LISTBOX HELP

P: n/a
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
Nov 27 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 28 '05 #2

P: n/a
what is the centre

Nov 28 '05 #3

P: n/a
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
Dec 8 '05 #4

P: n/a
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
Dec 8 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.