Prev: Unable to use filter in datasheet view or add criteria to query in design view
Next: Unable to use filter in datasheet view or add criteria to query in design view
From: John W. Vinson on 3 Mar 2010 18:58
On Wed, 3 Mar 2010 08:15:01 -0800, John <John(a)discussions.microsoft.com>
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]
First  |  Prev  | 
Pages: 1 2
Prev: Unable to use filter in datasheet view or add criteria to query in design view
Next: Unable to use filter in datasheet view or add criteria to query in design view