RE: Report Design

Well what it actually is... we currently have about 50 spreadsheets on Excel
that we are trying to convert over to Access, but we are only going to do it
if it will make running reports a little easier. As a trial I pulled some of
the data into Access and have been attempting to run reports with that data.
I have 3 tables that were created that I am trying to use. I can't make them
all one table because each table has information regarding a different audit
and I can't mix that information together. So what I'm trying to do is use
those three tables to run a report. I have 4 Column headings that I'm using
(D/C, RAC Date of Decision, RAC Decision, Appeal / Bypass). I would like to
be able to run a report or query of this information so that I can get a
total number of each different RAC decision Broken down by DOD, D/C and A/B,
but not broken down by table.

"Duane Hookom" wrote:

I don't understand what you are asking. It seems you want tables but not
table. My WAG is that you created multiple very similar tables rather than a
single table.

How about providing some details about your tables and what you are
attempting to report?
--
Duane Hookom
Microsoft Access MVP


"akemeny" wrote:

Hi,

My company is trying to convert from using Excel to Access for our
databases, however we are having trouble running reports. We have multiple
tables created and have reports, but we can not get it to run the way we need
it to. What I need it to do is have a master list of categories (ie:
Discharge Status) so that I can just run one report and have it pull from all
the tables without it including the table information. Is there a way to do
that?
.