report which give me orders per customer

[Dinictus]

report which gives me orders per customer

Hi,

I hava a simple system: level 1 has adres info. Level 2 holds orders for these adressen.
Now I want to create a report that gives me all the order which haven't been send yet. I have query for these data, it lookt like this this:

customer1 name1 hammer 5 sent:N
customer1 name1 screwdriver 4 sent:N
customer2 name1 screwdriver 10 sent:N
customer2 name1 drill 1 sent:N

I want a form that puts the order articles below the customer name like:

page 1:
Customer 1: name 1
wants:
hammer, amount 5
screwdriver amount 4

page 1:
Customer 2: name 2
wants:
screwdriver amount 10
drill amount 1


Can I do this with a report or do I have to look elsewehre?
Hope you guys can help me out!

thnks!

 

[Pat Hartman]

Use the query as the RecordSource for your report. Use sorting and grouping options to group each customer's data.

 

[Dinictus]

Yes I had the query as the source.

Sorting and grouping....I'll have a look at that.
Thnks!