Hi Richard. I have found your free lessonsn and tips and ticjs very helpfoyll for me. I am a doctor and I have costructed a data base fos the exams of my patients. I would like to reverse the columns wand row so to have in the first row left the names of each exam and the results in vertical orientation havig as a column header the dates of exms done. Thank you in advance.
Reply from Richard Rost:
This is surprisingly not that easy to do in Access. In Excel you can flip the axes easily with one click, but Access is really designed so that RECORDS go across in ROWS and FIELDS go down in COLUMNS. You could make a custom REPORT to display records this way using columns (like mailing labels), but it's not something that Access can do by itself.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 308.