queries & multiplication

[BloodshotVandal]

Hi all I was wondering if someone can help me with a problem I am having

Is it possible to get a query that combines information from 3 seperate tables (e.g. Table A, Table B, and Table C) and then multiply fields from two of them (i.e. Quantity from Table B and UnitPrice from Table C) and insert the result into a field from the first table (i.e. Price from Table A)?

I managed to get the query to combine the information from tables A, B, C, its the multiplication part that I struggling with.

Thanks in advance

 

[vbaInet]

Multiplication part?

[Qty] * [Price]

Look this up in Access help.

 

[BloodshotVandal]

Thanks for the reply, vbaInet. Tried what you suggested, but the price field on Table A seems to be empty...

Edit: Figured out where I went wrong. It works now.

 

[vbaInet]

Play around with your joins and ensure you have data in table A

 

[BloodshotVandal]

Thanks again for the reply vbaInet. The problem arose because I had an existing "Price" field in Table A, once I removed it it worked fine.

 

[vbaInet]

Glad to know that you've got it working.