Help with Design

[hagen31]

Hello all,

I am trying to create a quality database. I have created a couple tables and
run some queries to do some simple math. The tables store information based
on date and then run a report based on a start and an end date. This is fine
for individual tables, but is it possible to run a summary report for any
given month of the totals data that the queries produce from the tables? Or
is it best to use Excel becuase you can from the main Quality summary
spreadsheets to the month totals of the other spreadsheets. The main reason
my users would like Access is becuase of reporting functions, but have
analyzed this problem I believe it is best to continue to use Excel becuase
the spreadsheets are one-one relationships. What does everyone think? If you
think I should continue to use Excel is it possible to use Crystal Reports or
something similar to create better reports based on week,quarter,month, year
or what they need?

Thanks,

Austin

 

[KARL DEWEY]

What does a sample of data collected look like? Post a couple of records.

What would the report look like? How would it use the inputted data? Post
some output expectation information.

 

[ghillie5150]

What are your relationships between tables like? Remember, spreadsheets are
for snapshots of data, not true historical data storage and querying. Please
post the requested data and output.

 

[ghillie5150]

Spreadsheets are not designed to meet the needs of users requiring historic
data. This may also be a problem with how you have set up the relationships
between tables. With the correct relationships, a single table may have the
date, yet it will be accessable for query (and subsequent reporting)
funcitons from any other table.
Please post data and expected output as requested.