I have a table named Voucher with 3 field:
voucherCode (every voucher has a unique code)
ordernum (there can be many vouchers with the same ordernum)
vouchertype
The query that I cant manage to build is a query that returns a table that each row contains 3 field:
ordernum (grouped by)...