qry_PermitPrintDetail
Permit ID Expiry Date Zone Registration Number
1 30/09/2009 ALL KE06JFN
1 30/09/2009 ALL RICH
2 30/09/2009 CPARKS JE06 TKH
3 05/09/2007 ALL G6 777
3 05/09/2007 ALL JE88 GGJ
4 28/09/2008 CPARKS KE06 YHF
Basically, i want my mail merge to show like:
1, 30/09/2009, ALL, KE06JFN/RICH
2, 30/09/2009, CPARKS, JE06 TKH
3, 05/09/2007, ALL, G6 777/JE88 GGJ
|