Report 1 CustomerID + Orders

  • Thread starter Thread starter daniel
  • Start date Start date
D

daniel

Hia!

I have an Access database that keeps track of my
customers, employees, products and customer orders of the
products.

How can I create a report that shows only 1 customer with
their orders? Example;

Data in the database:
8 customers, 4 employees and 2 products.
All the customers made orders of both products. Let's say
customer8 has made 8 orders, customer7 made 7 orders
etcetera, etcetera...
Each customer has a ID
Click to expand...
I want a report of a single page with all the orders of
the customerID I select. I managed to let Access show all
the customers with all their orders on the same page, but
showing only 1 on 1 page is what I really need.

Thanks in advance!
Daniel
 
One way

look down 2 msgs, and take a peek at the code I have a question about.

I created a list box, and populated it from a query of my cooking
cycles (unique) or equivalent to your CusID.

You can then just select the CustomerID you want and print out any
report you want for that customer.

HTH

jdb
 
Back
Top