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)
voucherCode (the lowest for each ordernum)
vouchertype (the type of the voucherCode displays)
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)
voucherCode (the lowest for each ordernum)
vouchertype (the type of the voucherCode displays)