fundamental problem creating a Totals query

[rvd48]

im trying to create a field where by, 2 other fields are multiplied together: "qty" and "cost". so i set the criteria to: ="qty*cost" but all fields return blank.
im at a loss at where the problem is, this should be one of the easiest things to do in Access, but its not for me.

 

[KenHigg]

To start with, I doubt you actually meant to call this a 'Totals' query which generally speak do calculations across rows, looks like you need to do work across columns.

Anyway, what you need to do is instead of bringing down a fld in the query builder for your new column, do something like the following in the top row of the query builder:

myNewFld: qty * cost

Does this help?
Ken