Start/End date

  • 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...
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
.
Click to expand...

Solution by anonimous;

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.

Now, I want access to ask me to fill in a start and end
date before opening a report. How can I do that?

Thanks!
Daniel
 
Now, I want access to ask me to fill in a start and end
date before opening a report. How can I do that?
Click to expand...

Use the same steps that you used to get Access to ask you for the customer
id, except apply them to the Start and End date fields in your query.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Daniel said:
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
.
Click to expand...

Solution by anonimous;

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.

Now, I want access to ask me to fill in a start and end
date before opening a report. How can I do that?

Thanks!
Daniel
Click to expand...
 
Back
Top