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
|
|||
|
|||
Sum total calculation
Hello,
I would like to obtain a sum total on reports for billing codes that identify patient charges.I have various codes so i want to specify them by their respective code to obtain totals for each.Is this possible in reports? |
#2
|
|||
|
|||
Sum total calculation
How is this a "tablesdbdesign" newsgroup question?
Are you saying you want to select a billing code and prepare a report for that one code? Are you saying you want a report that lists each code and the total for that code? Are there any time constraints involved, or do you want all records in your database? What kind of data structure holds your data? -- More info, please ... Jeff Boyce Access MVP |
#3
|
|||
|
|||
Sum total calculation
Sorry about that,
I have a table for codes that identify the transactions in the invoice table.I guess the problem is how to identify one code from another(only six codes---three indicate amt paid and the other three amt due and hopefully have a total on a report.I thought the design of the code table could be done to accomplish this.Ultimately, i need a report that lists the codes and total for them....Please advise....thanks for your time -----Original Message----- How is this a "tablesdbdesign" newsgroup question? Are you saying you want to select a billing code and prepare a report for that one code? Are you saying you want a report that lists each code and the total for that code? Are there any time constraints involved, or do you want all records in your database? What kind of data structure holds your data? -- More info, please ... Jeff Boyce Access MVP . |
#4
|
|||
|
|||
Sum total calculation
Are you saying you want your code table to include a field that indicates
that a given code is either a payment or an amount due? Even without that, you can use a totals query on your transaction table, grouping by code and summing by amount. Of course, that depends entirely on the data structure in your transaction table... -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculation a running total w/out creating a circular reference er | Vredding | Worksheet Functions | 2 | July 23rd, 2004 08:11 PM |
Report showing current total, previous total and average total? | Richard Black | Setting Up & Running Reports | 3 | July 20th, 2004 01:22 PM |
Running sum used in total calculation? | Louise54 | Setting Up & Running Reports | 1 | June 29th, 2004 04:41 PM |
adding total cost from a month | Andrew | Worksheet Functions | 4 | May 17th, 2004 02:36 PM |
Total calculation out by .2 | S Findlay | New Users | 4 | April 24th, 2004 07:23 PM |