On Wed, 3 Mar 2010 08:15:01 -0800, 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!

What's the context? What's the structure of your table? Is this drawing from a
table, or from a crosstab query, or a spreadsheet, or what? Because if it's a
table, it's badly in need of normalization!
--

John W. Vinson [MVP]