Add figures in various tables and display result on Report, How?

[egims]

First, I want to thank the individuals who where so great in answering my last question.

I have an Overhead Expenses database and would like to add the various expenses - then have the sum display on a report, along with simular types of addition from which I must access other tables.

I have figured out how to do this using the wizzard for a specific table, but can't seem to get the job done when referencing other tables. I just get the little box that says #name. Any help is appreciated.

Ed

 

[willir]

egims

Looks at the lookup functions...

DLookUp
Looks for a specific field for a specific record dependent on a Where clause. Can be used in a form, a report, within VBA coding

Syntax:
DLookUp("[YourField]", "YourTable", "[YourField] = " & YourVariable")

Related functions...
DSum
DCount

Richard

 

[BattleDroid42]

I would avoid using these functions because they tend to be slow. Relating the tables and summing the values in a query behind the report would be better if possible.

Remember, wherever you go...there you are.