printing specific info

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

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.
 
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.
 
Back
Top