Access 2003 question

[Nocturnal]

How would I achieve by using a query to create something like this row value in one table * another row value in another table and have it output the answer either in a report or a query? Is this possible? I'm basically trying to calculate say a job which is $160.00 by my commission amount of 30% and get the answer of 160*.30.

 

[dderolph]

Been awhile since I've done anything like that in Access but I believe you can do it in a report. In other words, I'm quite sure you can set up formulas in report forms to do your calculation. I don't know whether you can create formulas in queries; I'm thinking not, but I may be wrong.

 

[Nocturnal]

ttt

 

[KLin]

Originally posted by: Nocturnal
How would I achieve by using a query to create something like this row value in one table * another row value in another table and have it output the answer either in a report or a query? Is this possible? I'm basically trying to calculate say a job which is $160.00 by my commission amount of 30% and get the answer of 160*.30.

You'll have to have some kind of a relationship between the 2 tables to accomplish this.