Sum total calculation

[Guest]

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?

 

[Jeff Boyce]

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?

 

[Guest]

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

 

[Jeff Boyce]

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...