A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help: table with all locations AND just one location



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2010, 06:12 PM posted to microsoft.public.access.reports
Sydney
external usenet poster
 
Posts: 8
Default Need help: table with all locations AND just one location

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!!
  #2  
Old May 13th, 2010, 05:12 PM posted to microsoft.public.access.reports
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Need help: table with all locations AND just one location

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!!
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.