can records from one table become fields in another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make the records from my assessment fields become the fields in my
results table. Any insight will be much appreciated.
 
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?
 
I want to make the records from my assessment fields become the fields in my
results table. Any insight will be much appreciated.

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
 
Back
Top