Fields......

[oliver_penney]

i have a function that comes up with text, say "FieldName2345" but what i actually want is it to return that field....

is that possible?

and i don't wanna do iif([Answer]="Field2345",[Field2345"],null)

cos there are too many possibilities!

thanx in advance

ol

 

[Russell Hauf]

Sorry, I'm not following. Care to give more info (maybe a more specific example - what exactly do you want to do?)?

Thank you,

Russell

 

[oliver_penney]

i have a field called [Provisioning Complete Month] which tells me what month an order finished provivisioning , e.g. "4" is complete in April 2002

i have revenue fields for that order such as [May02 Rev $] , [Jan03 Rev $]

but what i would like is... [Revenue 1 month after provisioning], [Revenue 2 months after provisioning]

so for an order with [Provisioning Complete Month] 5, the [Revenue 1 Month after provisioning] will take the [Jun02 Rev $]

ol

 

[Russell Hauf]

On 2003-02-14 05:50, oliver_penney wrote:
i have a field called [Provisioning Complete Month] which tells me what month an order finished provivisioning , e.g. "4" is complete in April 2002

i have revenue fields for that order such as [May02 Rev $] , [Jan03 Rev $]

but what i would like is... [Revenue 1 month after provisioning], [Revenue 2 months after provisioning]

so for an order with [Provisioning Complete Month] 5, the [Revenue 1 Month after provisioning] will take the [Jun02 Rev $]

ol

That's a tough one. What you should really do is to not have a field for each month's revenue. You should probably have a table where you have your Primary Key field(s), and Revenue and Revenue Date (or Revenue Month). Then you could run your query where Month(RevDate) = [Provisioning Complete Month] (or RevMonth = [Provisioning Complete Month]...or RevMonth = [Provisioning Complete Month], etc.).

Sorry, but I don't see another easy way to do what you want. If you keep your table structure how it is, you'll most likely have to just keep hard-coding the month you want.

-Russell

 

[oliver_penney]

aha

i see what you mean. a hefty re-write is needed in the long run, but i'll stick to excel tinkering in the short

thanx a lot

ol