Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    OK..here is the deal.
    I have a report in excel. It SHOWS all payments made by a patient. So, a patient could have mulitple rows for the same date of service.

    I am currently subtotaling in excel, taking the total and copying it to a row of information for that patient and then deleting all other rows. SO, I have one row with a total payment.

    Is there a way for me to do this in access...ultimate goal is to get it there anyway.
    Or a smarter way in excel???

    Thanks,
    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Reports in Access can group by one or more fields. They can display summary information such as group totals in the group header or group footer.
    If you leave the Detail section of a report empty, it will *only* display summary information.

    You can also use Totals queries to summarize data.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I agree with you 100%.

    What I need is to have just one record for that date of service with a total payment field. I use Date of Service and patient ID# as primary fields.

    A patient can have more than one date of service (that is a good thing). The accouting software gives me a report with every payment and I need just a total payments for that date of service.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can create a Totals query that returns the data you want, then (in design view) select Query | Make Table Query and specify a name for the output table. When you run the query by selecting Query | Run or by clicking the Run button on the toolbar, the records returned by the query will be saved to a table.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks ....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •