Form problem

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

Guest

I'm fairly new with Access so bare with me. I have a form to show fields
based on selection by the user from the combo box. In the table, it has the
fields for column headings and the dates for row headings and then the values
that go with them. However, when I view the information, I want to look at it
the other way around with the dates for columns and the fields for rows, but
I need the table set up that way so that I can manipulate the data
(add/subtract/multiply) or whatever I need to do. so basically I just want to
transpose it. How can I do that? I have made a bunch of text boxes for the
data, if you can give me an idea on the loop code I would need? Or if there's
an easier way to do this...let me know.
 
Lilbit:
Could you post your pertinent table defiinitions? In the form you are using,
are you using single form, datasheet or continuous forms mode? If you don't
know, open properties for the form and about 6 lines down, it should state
the default view.
Sam
 
It's in continuous forms mode and basically what I want it to do is instead
of showing the next dates information below the first one, I want it to show
it as a column. So if I had the date at the top, and all the information for
sales going down and then the next month's date (next row in the table) in a
column to the right and the information below it.
 
Back
Top