G Guest Oct 11, 2004 #1 I want to make the records from my assessment fields become the fields in my results table. Any insight will be much appreciated.
I want to make the records from my assessment fields become the fields in my results table. Any insight will be much appreciated.
D Duane Hookom Oct 12, 2004 #2 Would it be too much trouble to enter a few records from your your assessments fields and how you would expect them to display in your query?
Would it be too much trouble to enter a few records from your your assessments fields and how you would expect them to display in your query?
J John Vinson Oct 12, 2004 #3 I want to make the records from my assessment fields become the fields in my results table. Any insight will be much appreciated. Click to expand... Ummm... No. You don't want to do this. Storing data in fieldnames is NEVER a good idea! You can *display* the data in this way, dynamically, using a Crosstab query; but it would be bad practice to store that data. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
I want to make the records from my assessment fields become the fields in my results table. Any insight will be much appreciated. Click to expand... Ummm... No. You don't want to do this. Storing data in fieldnames is NEVER a good idea! You can *display* the data in this way, dynamically, using a Crosstab query; but it would be bad practice to store that data. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps