Unit Conversion on Reports

Hey all,

Im using Access 2002. I've got a database set up that keeps track of all the wastes in the plant. The wastes are divided by day, and then by type of product.

Right now all my reports give the results in lbs, as per what they have been input as. I'm trying to figure out how to convert all the lbs values into cost values.

I have a table set up [Product_Values] with the fields [Product], which is the products name as appearing in the main DB, and [Value] which is a manually input value for the $/lb of product.

I have a form with a large series of buttons on it that are used to open up the varying reports, so on this form I've been trying to add a checkbox or option button, which when clicked, will cause all the reports to report in $s instead of lbs.

Can anyone give me some advice on this? I know in Excel I would use something like VLOOKUP to compare the Database product name with the name of the product in my [Product_Values] table and from there get the value associated with it. I'm just unsure how to go about this in Access.

Thanks in advance :)

James

re: Unit Conversion on Reports

It may be easier for you to make a seperate query and report. And when they check the checkbox, it would open the other report instead.

re: Unit Conversion on Reports

How do you make a check box in a form change what a button on the from does?

Say there is 1 button, if the Checkbox is not checked, the button goes to Report A, if the Checkbox is checked, the button goes to Report B?

re: Unit Conversion on Reports

In the code of the On Click for the command button, you would have something along the lines of:

re: Unit Conversion on Reports

Thank you Rabbit, it's always the programming part that gets me.

re: Unit Conversion on Reports

I'm having troubl converting my data from my database.

Is there a way to add another column to a DB Table which is just a formula, so I've got my Raw data input in lbs, this column would just report that value in Dollars. I'm trying to do simple tests to get this working, by simply setting the default value of the field equal to the lbs number entered but I always get an error :(

Any ideas?

re: Unit Conversion on Reports

It is best if you don't store a calculated field in a table. It'd probably be better for you to make a select query that has the calculated field.

With that said, Access is not like Excel where you can have a field that is a formula. You have to use a query and then run that query whenever you want the calculations.