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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Report
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 |
#2
|
|||
|
|||
Access Report
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. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message ... 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 |
#3
|
|||
|
|||
Access Report
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? "Al Camp" wrote: 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. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message ... 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 |
#4
|
|||
|
|||
Access Report
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." -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message news 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? "Al Camp" wrote: 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. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message ... 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 |
#5
|
|||
|
|||
Access Report
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 "Al Camp" wrote: 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." -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message news 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? "Al Camp" wrote: 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. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message ... 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 |
#6
|
|||
|
|||
Access Report
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. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message ... 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 "Al Camp" wrote: 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." -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message news 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? "Al Camp" wrote: 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. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marilyn" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 vs. 2003 | Neil | General Discussions | 51 | February 16th, 2006 10:18 PM |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |