display multiple fields base on selection in one page (1 Viewer)

ice051505

Registered User.
Local time
Yesterday, 16:48
Joined
Feb 11, 2013
Messages
42
Hi dear all, I have a query like below
Cnt Type Time
1 TypeA 20/01
1 TypeB 23/01
4 TypeE 23/01
3 TypeC 14/02
24 TypeA 25/02
564 TypeD 12/03
116 TypeE 24/03
0 TypeB 15/04
27 TypeD 25/04

And I have a multiple listbox on my form to select type

If the selection from the listbox is TypeB and TypeE
I want my report looks like
Time TypeB TypeE
23/01 1 4
24/03 0 116
15/04 0 0

I already made the multiple listbox pass to report VBA code, but my problem is only one column field shows on the top, like if the selection is TypeB and TypeE, there only TypeB on the column field and won't give me all the select type on the same page
Hope anyone can help me out, thanks!
 

Users who are viewing this thread

Top Bottom