Microsoft Access Basic Question(s)

[iggyntangs]

Hey so I have a database and I created a query to take two values off a table and multiply them to give me a cost.

Now in the same query I want to sum all the costs (which are in separate fields obviously), how can I do this?

Thanks.

[username]

select sum(cost)
from table
group by XXXX

[calumniate]

So you obtained cost by multiplying two fields right? You could use a pivot table view at this point to sum that field. (Pivot table view found in bottom right corner)