IIF Record =
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!
|