Default Value

[t5amec]

Hey,

Ive got a table set up which is not calculating properly (or least i cant seem to get it to) Basically i have a row for quantity and a row for unit price. What i want to do in my table if possible is times the unit price by the quantity so it will come up in my reports which at the moment it isnt doing, as the default value is 0 in my table!
Might anyone be able to help me on this matter?

Thanx in advance

 

[Simon_MT]

You can does this in an underlying query to your report.

Sell = [Quantity]*[Unit Price]

Simon

 

[Dennisk]

you will require a query for the quantity and a query for the price. Include a unique identifier in both.

use both of these queries in another query linking on the unique identifier then add a column for your calculation.

however you will have to ensure every identifier in one query is in the other a visa versa.