Only if you post the SQL of the query that is failing.

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

John wrote:
The DLookup method works. I used:

Month03:
Sum(IIf((DLookUp("Month","Export_Data"))=3,[Apr]+[May]+[Jun]+[Jul]+[Aug]+[Sep]+[Oct],0))

You mentioned a faster way, but when I tried. I get and error saying the
expression contains and error or is to complicated to process. I have added
the "Export_Data" table to the query. Here is what I am typing.

Month03:
Sum(IIf([Export_Data].[Month]=3,[Apr]+[May]+[Jun]+[Jul]+[Aug]+[Sep]+[Oct],0))

Can you point me in the right direction?

"John" wrote:

I'm trying to update a query expression and not having much luck.

The origional expression pulled a value from a Form and then based on that
value summed the values from another table.

Month08: Sum(IIf(Forms![Summary Reports]![Report Month]=8,[Sep]+[Oct],0))

Now I want to point this expression to another table (not a form) in order
to retrieve the value. Basically I want it to read.

Month08: Sum(IIf([Export_Data].[Month] = 8,,[Sep]+[Oct],0))

Now the Export_Data table only has one record that I am manipulating via
VBA. Any help is greatly apprechiated.

Thanks!