If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
printing specific info
What I want to do is print various reports which show the
customer information along with information in specific fields, such as amount outstanding, whether they have paid, or if a check box has been ticked. I think this might have something to do with queries. Can someone tell me what it is that i need to do. I know this is probably a very basic question, but any help would be greatly appreciated. |
#2
|
|||
|
|||
printing specific info
Queries are generally necessary when using relational
databases since the information that you want resides in separate tables. When designing your database you should make sure that you create relationships between all of the related tables. So for instance if you have a Customer table and a table that has customer contacts you would design the tables to include a related field such as CustomerID so that when you want to pull related information out of these tables Access has a link to the records that it searches for. In your case, you may have a Customer table, an OrderHeader table and an OrderDetail table. Linking these together would be done by using something like CustomerID between the Customer table and the OrderHeader tables then using OrderID between the OrderHeader table and OrderDetail table. You create these relationships using the "Tools"..."Relationships" window by dragging the related fields onto each other from table to table. When you create the query that will feed your report, select these tables in query design and choose the fields that you want on your report. You can the group your selections by things like Customer, followed by OrderID. Creating expressions in your queries and using calculated fileds in your reports may also be necessary to display the data in a way that you want to see it. -----Original Message----- What I want to do is print various reports which show the customer information along with information in specific fields, such as amount outstanding, whether they have paid, or if a check box has been ticked. I think this might have something to do with queries. Can someone tell me what it is that i need to do. I know this is probably a very basic question, but any help would be greatly appreciated. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
printing specific columns | Fayette | General Discussion | 7 | September 16th, 2004 09:55 PM |
Skip printing specific Rows | Erik Merk | Worksheet Functions | 2 | July 7th, 2004 06:18 PM |
Pulling Specific info to transfer to another worksheet | bleu808 | New Users | 4 | May 8th, 2004 02:29 AM |
getting specific info from all *.xls in a given folder | Kronos | Setting up and Configuration | 0 | April 20th, 2004 07:48 PM |