find a sum in an expression

[cppiston]

Thanks ahead of time.... I have a report that gets its info from a table... the table comes from a make-table query...

Inside of the Make-Table query are 4 tables..

Ok.. The problem....

I have 2 variables comming from the table.... I want a text box to show the sum of 2 other values from the table....

What is the expression???

Thanks,
Lance

 

[lameid]

Your control source in the report should be
= Field1 + Field2

in a query
NewFieldName: Field1 + Field2

Make table queries are generally a bad idea. Why can't you simply use a query as the source of the report?

If you post the SQL here someone may be able to simplify it. (Open the query in design view, change the view to SQL and copy and paste the SQL into the forum.)