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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OneNote and MS Forms 0
Autonumber field in Excel that behaves the same as Access 0
How do I clear a form? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
MS Project Center-Autolink column fields 0
List all tables, including document structure 0
Copy previous record into form field 0
Adding data to MS Access from csv file 0

Top