Run queries off of a decision table

[Katie06]

How to run queries off of a decision table in access?! Urgent!

I am currently building an access project and it requires us to use a decision table, specifically with calculating different selling prices based on different consignment rates. We have the table all set up, but now how do we use it in access to get the query results we need? If you know, please message me, asap! Thanks in advance, Katie

 

[o1110010]

I am currently building an access project and it requires us to use a decision table, specifically with calculating different selling prices based on different consignment rates. We have the table all set up, but now how do we use it in access to get the query results we need? If you know, please message me, asap! Thanks in advance, Katie

Sounds like you'll either have to use SQL statements or VBA coding. If you give us more details on the tables and desired output, we can help you out. (What's the table called? What fields are in the table? What is the setup of the fields (non-default properties.. data type, etc)?)

 

[Katie06]

The system is for a store that sells everything on consignment. I have no previous access experience, so any help would be much appreciated. The Decision table consists of all the options for how much the consignment rates are depending on if there is a sales dicsount or if the artist is highly rated, their rate will be higher, there are 12 different amounts of fees that could be charged. Currently we have the table in excell, but i need to move it into access so that when i "complete a transaction" in the access database, we can calculate the amount of consignment fee to pay the artist, as well as the total amount to charge the customer, and the amount the business recieves. We know that we need to run queries on the information, but is there an efficient way to do this?

Thanks very much!

Katie

 

[o1110010]

The system is for a store that sells everything on consignment. I have no previous access experience, so any help would be much appreciated. The Decision table consists of all the options for how much the consignment rates are depending on if there is a sales dicsount or if the artist is highly rated, their rate will be higher, there are 12 different amounts of fees that could be charged. Currently we have the table in excell, but i need to move it into access so that when i "complete a transaction" in the access database, we can calculate the amount of consignment fee to pay the artist, as well as the total amount to charge the customer, and the amount the business recieves. We know that we need to run queries on the information, but is there an efficient way to do this?

Thanks very much!

Katie

ooOOO! Pre-existing calculations and data!

If you attach the Excel file, (if it's too big, try zipping it) it would help us help you. (This "decision tree/table" is already in the Excel file, right?)

 

[Katie06]

ooOOO! Pre-existing calculations and data!

If you attach the Excel file, (if it's too big, try zipping it) it would help us help you. (This "decision tree/table" is already in the Excel file, right?)

It is already in excell, but this message wont let me attach it, it says its an invalid data type.

Any suggestions?

Thanks, Katie

 

[o1110010]

It is already in excell, but this message wont let me attach it, it says its an invalid data type.

Any suggestions?

Thanks, Katie

If you have winzip installed on your computer....
Explore to the file.. then Right-click on the file.. (default settings of winzip will add itself to this menu).. goto winzip.. then Add to TheFileName.zip.

Then attach the zip. :-D

 

[Katie06]

If you have winzip installed on your computer....
Explore to the file.. then Right-click on the file.. (default settings of winzip will add itself to this menu).. goto winzip.. then Add to TheFileName.zip.

Then attach the zip. :-D

Thanks, katie

 

[Katie06]

If you have winzip installed on your computer....
Explore to the file.. then Right-click on the file.. (default settings of winzip will add itself to this menu).. goto winzip.. then Add to TheFileName.zip.

Then attach the zip. :-D

Thanks for the advice, some direction for the this procedure would be great.

K

 

[o1110010]

Hand-off

To any members who view this thread, please pick this up for I have fallen out of time.

Good luck Katie!

 

[Katie06]

The "decision table" needs to be normalized. You will not be able to use it easily in its present form. Without knowing the business rules, I can't do it for you but you should be able to reduce the table to a key and a percentage value. The "key" may actually be several fields but the important thing is that EVERY piece of the key MUST exist in the Artist's record so that the Artist's record can be joined to the "decision table" to obtain a SINGLE rate.

Firstly, how do you suggest that we change it? Second, what do you mean by the key? Is that like the most important factor from the table?

Thanks,

Katie