Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My Apologies, I accidentally created this in the Excel section. I have
created the same post in Access General Questions. Sorry for the duplicate post. "Matt Cromer" wrote: I would like to replace the hard coded field names (i.e. [200626]) with dynamic field names selected from a drop down box. The drop down box should be created using field names from the history table...these field names change weekly. SELECT History.[Item Nbr], Sum(History.[200626]) AS SumOfField 1, Sum(History.[200630]) AS SumOfField 2, Sum([200630]-[200626]) AS Change FROM History |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Ranges: Speed Issue | Excel Worksheet Functions | |||
#NUM! in Date field calculation | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |