grouping

[amavadia]

I have created an invoicing system for a CD shop
There is a transaction table which has each individual cd sold as a seperate transaction. Each transaction has an order number, so there can be more then one cd sold per order, but they all still have their own record in the table.

im now invoicing each order by mail merge based on a query that finds all the details on every transaction but wht ive found is that the mail merge puts each transaction onto a different page even if its from the same order number as another.

does anyone know how to group each order in the query so that all the items in one order come in a single invoice?

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?p=486644&posted=1#post486644

 

[amavadia]

sorry, just needed a quick reply, gotto hand it in tomorrow!
lol

 

[amavadia]

anyone shine a light on this problem plz!?

 

[Jonathan Kok]

I would imagine this is a function of the mail-merge. Have you considered building a report in Access to do the invoicing instead? This type of report is pretty standard, and Access will easily build it for you.

 

[amavadia]

i have to have an element of dynamic data exchange in it (its coursework) and this was the 'easiest' way.

anyone? :s

 

[workmad3]

Its a property of the mailmerge that it puts each record (i.e transaction) on a seperate page, afaik. However, what you may be able to do is write a quick VBA function in word that grabs the values you want and puts them in place, rather than relying on the mail merge.

 

[amavadia]

i have very little knowledge of vba. any chance you could explain how to do it?