Prev: Multiple lines from different tables in a report detail
Next: Showing field after page 1
From: Sydney on 12 May 2010 13:12
Hello!

WHAT I WANT TO DO:
I'm trying to build a report that will summarize quarterly data for
each of my company's locations and display it along side aggregate
data.

PROBLEM ENCOUNTERED:
I built a table with five columns (item, all count, all %, location
count, location %), but I can only get it to display the location
count and % in both sets of columns.

MY LEVEL OF EXPERIENCE:
I've never used the reporting function before and I'm finding both my
Missing Manual and usual on-line resources (Lynda.com, microsoft.com)
to be pretty thin on anything beyond the most basic reporting
functions. Certainly nothing about how to put together a table with
data from two different queries. (Unless you can use the same query
but somehow set the parameters differently for two columns?)

ADDITIONAL INFORMATION ABOUT MY DATA:
My company has several different kinds of locations (e.g. warehouse,
retail, express retail) that each need to be aggregated separately.

I'd like my report to display something along these lines:
--------
Report Header: [Warehouse] Report - [Q1 2010]
Page Header: [Warehouse] [5]

Table 1) Items in Stock
Table Column Headers: Item, All Warehouses Count, All Warehouses %,
Warehouse 5 Count, Warehouse 5 %

Table 2) Employees by Role
Table Column Headers: Job Role, All Warehouses Count, All Warehouses
%, Warehouse 5 Count, Warehouse 5 %

Table 3) Employees by Year
Table Column Headers: Year, All Warehouses Count, All Warehouses %,
Warehouse 5 Count, Warehouse 5 %
--------
In my ideal world, when I open the report, it will ask me to choose
the year, quarter, location type and specific location. Then all I'll
have to do is pdf it and send it off to the location in question,
rather than my current rather labor-intensive process of manual
changing all the values in a report template in Publisher.

THANK YOU in advance for any help you can offer!!
From: KARL DEWEY on 13 May 2010 12:12
You are using the wrong terms. An Access report does not have tables.
Table store data in fields. What it appears that you are talking about is
subreports.

You did not say anything about your table structure - names of the fields
and their datatypes, and relationship to other tables.

Provide that information. If you have developed any queries then post the
SQL for them by opening in design view, click on VIEW - SQL View, highlight
all, copy, and paste in a post.

--
Build a little, test a little.


"Sydney" wrote:

> Hello!
>
> WHAT I WANT TO DO:
> I'm trying to build a report that will summarize quarterly data for
> each of my company's locations and display it along side aggregate
> data.
>
> PROBLEM ENCOUNTERED:
> I built a table with five columns (item, all count, all %, location
> count, location %), but I can only get it to display the location
> count and % in both sets of columns.
>
> MY LEVEL OF EXPERIENCE:
> I've never used the reporting function before and I'm finding both my
> Missing Manual and usual on-line resources (Lynda.com, microsoft.com)
> to be pretty thin on anything beyond the most basic reporting
> functions. Certainly nothing about how to put together a table with
> data from two different queries. (Unless you can use the same query
> but somehow set the parameters differently for two columns?)
>
> ADDITIONAL INFORMATION ABOUT MY DATA:
> My company has several different kinds of locations (e.g. warehouse,
> retail, express retail) that each need to be aggregated separately.
>
> I'd like my report to display something along these lines:
> --------
> Report Header: [Warehouse] Report - [Q1 2010]
> Page Header: [Warehouse] [5]
>
> Table 1) Items in Stock
> Table Column Headers: Item, All Warehouses Count, All Warehouses %,
> Warehouse 5 Count, Warehouse 5 %
>
> Table 2) Employees by Role
> Table Column Headers: Job Role, All Warehouses Count, All Warehouses
> %, Warehouse 5 Count, Warehouse 5 %
>
> Table 3) Employees by Year
> Table Column Headers: Year, All Warehouses Count, All Warehouses %,
> Warehouse 5 Count, Warehouse 5 %
> --------
> In my ideal world, when I open the report, it will ask me to choose
> the year, quarter, location type and specific location. Then all I'll
> have to do is pdf it and send it off to the location in question,
> rather than my current rather labor-intensive process of manual
> changing all the values in a report template in Publisher.
>
> THANK YOU in advance for any help you can offer!!
> .
>
 | 
Pages: 1
Prev: Multiple lines from different tables in a report detail
Next: Showing field after page 1