function that returns the field name

[AccessMan]

I have a need for a calculated field in a query based on an expression that
includes a function that returns a string containing a field name from an
included table. Is there such a function?

Thanks!

 

[Jerry Whittle]

I got a bad feeling about this. If your field names have 'meaning' then the
table structure is wrong. For example if you have field names like January,
February, March, etc., you'll never get a query to run efficiently or even at
all.

Maybe provide some samples of what you have and need.

 

[AccessMan]

The table structure is fine. You've convinced me though that I need to try a
different approach to solving my problem. Describing what I am trying to do
is proving to be too tedious, which is a sure sign that I'm going down an
inadvisable path. Thanks for your response!

 

[Jeff Boyce]

I'm with Jerry on this.

If you are trying to "calculate" which field to work with, your data
structure may not be well-normalized.

"So what?" you ask? So the relationally-oriented features and functions
that Access provides won't be of much help as you come up with work-arounds
(AKA, "kludges") to try to get Access to do something it wasn't designed to
do.

Feel free to post back here or in tablesdbdesign for feedback on your table
design...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP