Hi dear all, can anyone gove me little help?
I have two forms, one is for selection and the other one is fo display the result
example of the display report form right now shows:
year Area1
1993 Vehicle 5
1993 Train 6
1994 Vehicle 1
....
the Area and transport type are all passed from the multiple selection list box in my selection form.
I want it shows like
Area1 Area2 Area3....
1993 Vehicle 5 6
1993 Train 6 14
1994 Vehicle 1 15
1994 Train 56 2
1995 Vehicle 37 0
1995 Train 5 19
I just hope to make my form display multiple column base on my selection
I attached a sample db here since I am a really bad explainer
Really needs some help here, Thanks a lot!!!
I have two forms, one is for selection and the other one is fo display the result
example of the display report form right now shows:
year Area1
1993 Vehicle 5
1993 Train 6
1994 Vehicle 1
....
the Area and transport type are all passed from the multiple selection list box in my selection form.
I want it shows like
Area1 Area2 Area3....
1993 Vehicle 5 6
1993 Train 6 14
1994 Vehicle 1 15
1994 Train 56 2
1995 Vehicle 37 0
1995 Train 5 19
I just hope to make my form display multiple column base on my selection
I attached a sample db here since I am a really bad explainer
Really needs some help here, Thanks a lot!!!