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
|
|||
|
|||
How do I perform a calculation in a report and/or query?
I'm trying to produce a report that I need to count the number of member
id's, but the member id could be listed more than once. I only want to count it once. My report looks like this: Provider Id GrpNo. MemberId CaseNo. FromDate ThruDate Any suggestions would be great. |
#2
|
|||
|
|||
How do I perform a calculation in a report and/or query?
Create a totals query (or series of queries) that is similar to your
report's record source. Have it return only one record that is the count that you need. Add this query to your report's record source and don't feel obligated to join it to any other table (as long as it returns only a single record). Add your count field to the query grid and it will be available in your report. -- Duane Hookom MS Access MVP -- "LisaK" wrote in message ... I'm trying to produce a report that I need to count the number of member id's, but the member id could be listed more than once. I only want to count it once. My report looks like this: Provider Id GrpNo. MemberId CaseNo. FromDate ThruDate Any suggestions would be great. |
#3
|
|||
|
|||
How do I perform a calculation in a report and/or query?
Hi Duane,
Your suggestion works partially. It gives the total number of the field to count, but, the other record duplicates itself for many times. How can this problem be solved? Please let us know. Thanks, Sazed Duane Hookom wrote: Create a totals query (or series of queries) that is similar to your report's record source. Have it return only one record that is the count that you need. Add this query to your report's record source and don't feel obligated to join it to any other table (as long as it returns only a single record). Add your count field to the query grid and it will be available in your report. -- Duane Hookom MS Access MVP -- "LisaK" wrote in message ... I'm trying to produce a report that I need to count the number of member id's, but the member id could be listed more than once. I only want to count it once. My report looks like this: Provider Id GrpNo. MemberId CaseNo. FromDate ThruDate Any suggestions would be great. |
#4
|
|||
|
|||
How do I perform a calculation in a report and/or query?
Does your new "totals query" return only one row?
-- Duane Hookom MS Access MVP -- "Sazed" wrote in message ups.com... Hi Duane, Your suggestion works partially. It gives the total number of the field to count, but, the other record duplicates itself for many times. How can this problem be solved? Please let us know. Thanks, Sazed Duane Hookom wrote: Create a totals query (or series of queries) that is similar to your report's record source. Have it return only one record that is the count that you need. Add this query to your report's record source and don't feel obligated to join it to any other table (as long as it returns only a single record). Add your count field to the query grid and it will be available in your report. -- Duane Hookom MS Access MVP -- "LisaK" wrote in message ... I'm trying to produce a report that I need to count the number of member id's, but the member id could be listed more than once. I only want to count it once. My report looks like this: Provider Id GrpNo. MemberId CaseNo. FromDate ThruDate Any suggestions would be great. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
calculation based on a calculated value in a report | steely via AccessMonster.com | New Users | 2 | June 3rd, 2005 08:06 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |