Full Version: creating a form similar to a pivot table
UtterAccess Forums > Microsoft® Access > Access Forms
I am trying to make a form and Im not exactly sure how to get started. I have a transport company and i would like to create a schedule for my vans. I would like it to be very similar to pivot chart. I need the y-axis to be (time)and x-axis to be (van #) and the information section will be the transport information. the problem with the pivot table is its versatility.is there any way i can design this form so that when in order is taken, and a van and time is assigned it, the tranport information will be plotted in the corresponding square? If anyone has any suggestions or examples that can get me started i would greatly appreciate it. thanks
You are focusing on the output of the data, rather than the input and storage. What do your tables look like? How are you capturing the data?
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.