formula to show price time qty

[james_halliwell]

[SOLVED]formula to show price time qty

Hi everyone,

i am putting together a simple database for a friend my knowledge of access is very limited, i have a form with a dropdown box i want to be able to type the quantity in and it shows the price times by the quantity but have no idea how this would be achived

please could someone have a llok at the database and show hows its achived or describe how this done

thanks in advance

 

[John Big Booty]

You can use an unbound text box to show calculated values. In the control source put;

=YourPriceFieldName*YourQuantityFieldName

The attached has sample that uses a sub form to allow multiple order lines and totals each and gives a grand total.

 

[james_halliwell]

=YourPriceFieldName*YourQuantityFieldName

The attached has sample that uses a sub form to allow multiple order lines and totals each and gives a grand total.[/quote]

Hi there thanks for your responce but im struggling i want to show the price of the beer selected i have the combo box to pickup 2 columns (beer name & Price are field names) i then created a text box and put the below code in but nothing shows

=[Combo0].[Column](2)

is there somthing im missing

 

[John Big Booty]

One thing you need to remember with Combo Boxes (and list boxes for that matter) is that they are Zero indexed. This means that the columns are numbered from Zero up, so the first column will be [Column](0) the second column will be [Column](1) and so on.

 

[james_halliwell]

Many thank fot your help

i would never of guessed that they are zero indexed

rep'd your your help and fast responces

 

[John Big Booty]

Glad to have helped, and got you past that little obstacle