Adding number fields together in a pass-through query?

[terrym]

I must be doing something really obviously wrong here, but I'm having no luck adding together some number fields in a pass-through query.

I want something like:

select
field1 "First Number",
field2 "Second Number",
field1+field2 "Total"

from
table

Thanks.

 

[Brianwarnock]

Don't know what you coded but doesn't something like

SELECT field1, field2, [field1]+[field2] AS total
FROM Table1;


work?

 

[terrym]

Thanks, that's great.