display Multiple columns pass from the multiple selection listbox to report (1 Viewer)

ice051505

Registered User.
Local time
Yesterday, 19:24
Joined
Feb 11, 2013
Messages
42
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 :p

Really needs some help here, Thanks a lot!!!
 

Attachments

  • Sampledb.JPG
    Sampledb.JPG
    7.6 KB · Views: 136
  • SampleDB.mdb
    1.3 MB · Views: 127

jdraw

Super Moderator
Staff member
Local time
Yesterday, 22:24
Joined
Jan 23, 2006
Messages
15,364
I am a really bad explainer

Suggest you try - WHAT does the data represent? WHAT are you trying to do?
If you had to tell it to someone at McDonalds what your issue is ,and that person doesn't know you and doesn't know Access or database,
WHAT would you say?
 

ice051505

Registered User.
Local time
Yesterday, 19:24
Joined
Feb 11, 2013
Messages
42
the data represent the number of people in different group(children, elder....etc) visit different area by different transport from 1992 to 1999

The area, transport and group selection is from the multiple selection listbox

by select the area, transport and group type, it should give me the number of people in different years

Now my database is display all the different area in one column, but I need them to display in the row direction on the form, just like the example I provide:

-------------Area1 Area2 Area3....
1993 Vehicle ---5---- 6------8...
1993 Train -----6----14-----26...
1994 Vehicle---1-----15-----0...
1994 Train-----56----2------19...
1995 Vehicle---37----0------7...
1995 Train-----5-----19-----2...
........
I hope this would help to explain my problem, Please help me, thanks
 

ice051505

Registered User.
Local time
Yesterday, 19:24
Joined
Feb 11, 2013
Messages
42

Users who are viewing this thread

Top Bottom