Reports

  • Thread starter Thread starter rich
  • Start date Start date
R

rich

Let me start by saying I'm not very experienced with Access but
hopefully someone here can help me.

I have database which i have created from data imported from Excel.
What i want to do is create individual reports for each record in the
database. For example my table consists of 100 records, each record
contains sales data on a quarterly basis over the last 2 years, the
primary key for each record is the shop name which is defined by it's
area (i.e. london, portsmouth, edinburgh).

What I want to do is create individual reports for each shop showing
their (and only their) sales data over the last two years. I can only
seem to create a report which churns out all the data on a given field
or fields, not reports which only give data for the specified
individual record.

Can anyone help?
 
Hi Rich.
First it wuld be interesting to know how your data is
organized in the table. From your description it does not
seem that you are using a query as the source of your
report.
If indeed each record (line) contains the information such
as shop and ther could be multiple lines pertaining to
that shop. You could start with creating a table type
report which you would than group by shop and an
appropriate header and possibly a footer for a summary.
Hope this gets you started.
Fons
 
One way would be to create a Query for each shop, then
create a report for each query.

Charlie O'Neill
 
Back
Top