Access Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Access - I have learned how to manipulate data to make queries in
Access. These queries give total counts of other queries, with me so far? I
currently take them out of Access manually and put them in a word report
which I then email to certain people. I would like to take those total count
queries and put them in an Access Report automatically. Can this be done
giving me step by step instructions?

TIA
 
Marilyn,
Reports are just printouts of data that are delivered to the report via a
table, or more often, a query.
Just like a form, a report has a RecordSource that usually consists of a
table or query that indicates to the form the records (and associated
fields) that you want to see displayed on that form.

If you have a query that delivers the data (records) you want, just use
that query as the RecordSource for the report. Place those query fields on
the report in the way you want them displayed, and then that report can be
emailed via the SendObject command... directly from Access.
 
that is very interesting what you wrote but when I tried to the report using
the total queries, a box pops and tells me it can not be done. What am I
doing wrong? Which queries using the report wizard do I need? The original
and the total count one?
 
Marilyn,
It's not possible to determine what's specifically wrong given the
information provided.
Do you have 2 queries?
One with detail, and one that totals those details?
Is the detail query a "pass-thru" query for the totals query?
If that's so, a report based on your "details" query can total the data
values themselves using the Grouping and Sorting functions of reports.

For example, let's say you list all your Customers (and addresses) in a
query, and use that as the RecordSource for the report. The report could be
grouped by State, and calculate the count of customers from each applicable
state. The report itself has the ability Sum, Avg, Count, etc... the data
you supply it.

Rather than try to deal with the whole report process, give us more
information about your "details" query. (A couple of example records, with
just the key values would be good)
Also, we'll need to know what your trying to total out of those fields.

But, it's a bit beyond the scope of the newsgroup to try to write, in
detail, a description of "how do I design/create a report." You'll have to
familiarize yourself with the basics of designing a report, sort and
grouping your data, and how to calculate values in reports. And please keep
in mind that "wizards" are limited in their capabilities, and can sometimes
be more troublesome than just designing a report from "scratch."
 
Thank you for your help - okay let me try an explain what I am doing. I have
a report that I import into Access from Excel to form a table. I then create
queries based different the different criteria such has weight, class and
quoteid. I use quoteid as the similiar factor in all. For instance I have one
query with quoteid and weight filtering out different weights. Then using
that same query I do another query that counts the quoteid. I take the last
query which has the count in it and base a report in word off of that. Is
there a simplier way of doing this?

I know there is probably a better query that would do that all in one but I
am just learning how to use Access which is a never ending process.

TIA
Marilyn
 
Marilyn,
Well, yes... you should be able to accomplish what you need in one query.
Using the query design grid, select View/Totals to create a "Totals" query,
where you can GroupBy and Count, Sum, Avg, etc... the fields you need to
calculate upon. A totals query can also handle your criteria requirements
to deliver just those records you want to see. Access Help, or any Access
"how-to" reference book will help you understand how to create Totals
queries.

That would be the best solution... but...
if your present totaling query delivers the records and totals you want to
see, and you feel more comfortable using the queries you have now, then make
that last "totaling" query the RecordSource for your report.
Your current detail query and associated criteria can continue to be a
"pass-thru" query for your current totaling query, but... the final totaling
query is the one the report should use.
 
Back
Top