can records from one table become fields in another?

B

BMacKinney

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

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

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
 
Top