Access question

[mstrbfg]

I have created tables and forms in access 2002. In the tabel i want to beable to add a formula to multiply two fields and have a total at the end of the table. Then i can have thoes numbers display in the report.

How do i and where do i insert the multiplication formula in the table. I know how to do it in Excel. but dosent seem to work in access

Brett

 

[Shirley]

You would have to create a new query of the table and insert a new field.

For Example:

Total: [1stField]*[2ndField]

 

[mstrbfg]

Thanks for the help but i am still not getting it to work.
I created a query for my table i have a cost column and a Qty column. i want to have at the bottm of a report a total cost based on the number of items. I created a query but am not sure where to add TOTAL:[Qty]*[Cost].

in the design view i created a sum colum and tried to make the link that way, but nothing shows at the bottom of the report statnig total.

I hope this is not to confusing

Brett

 

[dhookom]

Did you create a calculated column in your query as Shirley suggested?
Total: [Qty]*[Cost]
Then in any report header or footer section (other than Page sections) you can create a text box with a control source like:
=Sum([Total])


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]