A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sum total calculation



 
 
Thread Tools Display Modes
  #1  
Old August 12th, 2004, 10:26 AM
external usenet poster
 
Posts: n/a
Default 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  
Old August 12th, 2004, 12:43 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default 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  
Old August 12th, 2004, 02:30 PM
external usenet poster
 
Posts: n/a
Default 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  
Old August 13th, 2004, 12:51 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.