im creating a query which is basically "Price" of selected CPU X "Unit".
the problem is the price is in the component field as you can see here
in design view, i have made the statement:
Line Total:Sum([AMDprocessors1]*[unit])
as you can see here
if you look back into the 1st link, the "line total" doesnt come back with anything, that is down to it selecting the actual CPU instead of the price next to it.
what do i need to put into my statement to make it select the price of the CPU?
the problem is the price is in the component field as you can see here
in design view, i have made the statement:
Line Total:Sum([AMDprocessors1]*[unit])
as you can see here
if you look back into the 1st link, the "line total" doesnt come back with anything, that is down to it selecting the actual CPU instead of the price next to it.
what do i need to put into my statement to make it select the price of the CPU?
Last edited:
