BloodshotVandal
Registered User.
- Local time
- Today, 12:04
- Joined
- Nov 19, 2009
- Messages
- 17
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
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