Field Header in Query based on Other Field Data

[islu0102]

I'm not exactly sure how to ask this, but here goes. I have two tables that are joined - called A and B. A has two fields, "PLACE" and "RAND" and is joined to B via field "RAND". Other than "RAND", B has several fields named 01 TOTAL, 02 TOTAL, 03 TOTAL, etc...for about 60 fields.

The "PLACE" field in table A has data that is 01, 02, 03, ect.... How do I structure a query so that whatever "PLACE" is, I can match the XX TOTAL value? In other words, i need to have the query field header be somehow dependent on the value in "PLACE".

Is this even possible? Thanks for your any help you can give.

 

[rzw0wr]

B has several fields named 01 TOTAL, 02 TOTAL, 03 TOTAL, etc...for about 60 fields.

When I see a post with this wording I start to wonder if the tables are correct (normalized).
Can you post a picture of your table structure?


Dale

 

[islu0102]

A valid point, but as I haven't created anything yet, the information provided is theoretical, and I just made up names for the fields and tables. I haven't actually constructed anything yet. Of course I will work to see that everything is normalized.

I'm not really at liberty to post a picture of the information, as it's confidential, so I think I would need to re-build everything to visually show you. I'll do my best, if that's what you need. I apologize if my explanation skills aren't up to snuff.

I will say that the tables I will be using will not be created by me, so I will be stuck with how they are currently designed.

 

[rzw0wr]

You are doing fine.

I will say that the tables I will be using will not be created by me, so I will be stuck with how they are currently designed.

Been there, Had this done to me more than once.
Keep us posted.
Dale

 

[islu0102]

Well, I can't figure out how to fix my issue, so I created a work around that involved creating a table for the field I was needing and appending it 60 times to add all of the data in the correct format for me to extract it. Whew! Fun.

Anyhow - if anyone runs across a solution in the future, i would love to see it. Thanks!