Report 1 CustomerID + Orders

[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

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

 

[Guest]

-----Original Message-----
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...
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
.

I think that in your query under the customer-id field,
on the criteria line you can type [enter Customer-ID]
and save the query. Then when you run the report, a pop-
up will appear asking you to enter the customer-id. This
should limit the report to the specified customer.

 

[Daniel]

-----Original Message-----

-----Original Message-----
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...
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
.

I think that in your query under the customer-id field,
on the criteria line you can type [enter Customer-ID]
and save the query. Then when you run the report, a pop-
up will appear asking you to enter the customer-id. This
should limit the report to the specified customer.
.

Thank you very much! I had no problems using your solution
even though I'm new with Access.
I tried some different Criteria aswell (like entering date
of orders), this worked but I cannot find a solution for
entering start and end date. Do I need 2 different fields
in my order table to do so? Like StartOrderDate and
EndOrderDate or is this built in Access?