One address multiple info

DvDj

New member
Local time
Today, 11:31
Joined
Jul 2, 2010
Messages
8
I have a table holding customer details and a table that holds order details. One company can have multiple orders. I am trying to design a report that will display just the one companies address details but all of their order details and i don't know how to restrict the report to just show this.
Can you point me in the right direction for tutorials, or if there is an easy answer, perhaps you could outline it for me.

Thanks for your time
 
A report needs a Query to select the data (when data from more then one table is required) and this is the reports Data Source.

You need to research Select Queries and how to get the data you require with using same.

Often there can be three tables, or more, in what you are doing.

CustomerTable holds Customer Data, OrderHeaderTable holds order header data and OrderDetailsTable holds order Item , qty, price details.

Your Select query would select the CustomerID from the first Table, the OrderID from the 2nd table and Order Details from the third table.

Your query criteria will be on CustomerID and OrderID and you should not have a problem with data from other orders being returned.

Have you started your query?
 
Many thanks for your time and effort PNGBill, it is much appreciated.

I have gone away and started building a query based on your advise and all is going well so far.

I have a table that lists the orders and the company that placed the order. I also have a table with the address details of the company.

I have constructed a query that when run first asks for the company name which the user types in and then the query returns all the orders placed by that company. Perfect except i just want the address details of the company to appear once at the top of the report and the order details listed below.

Is there a way of doing this?
 
The address will appear on each record in the query but when you construct you report, put the address in the Report Header section of the report and it will only show once.

Fields shown in the details part of your form (text Box Controls) will repeat for each record and in the Form Header just once and in the Form Page header, on each page.
 
As you have probably gathered I'm a newbie to Access, but your help and advise PNGBill has resolved my issue and i have now achieved my goals!!

Many, many thanks
 

Users who are viewing this thread

Back
Top Bottom