![]() |
|
#1
|
|||
|
|||
![]() Quote:
If I understand Access' reporting capabilities (and I may not!), I don't think I'll have to do mail merges right now. Our health care-specific accounting package has all of the information needed for mailings, and since mass mailings come out of the business office, they'd continue using that program. This project is not meant to replace that program but rather store data and create reports otherwise unavailable to us. What I was planning on doing, for now, was just running with the Excel workbooks and then importing them to Access when I had the forms ready. (I'm comfortable that the data entry folks can use the bulky spreadsheet I created!). In fact, our hospice has already started using the workbook I created for them. In giving it more thought, I can see why it's necessary to interface with both programs. Our hospice workbook automatically calculates the next assessment period, which is vital for hospice operations, and I doubt there's a way to comfortably replicate these calculations in Excel. Maybe a linked workbook is the answer, I don't know. I have a lot of researching to do! Also, there are some sample reports hidden in the Excel workbook I uploaded. While the links are broken (the reports were designed early in the process), you can see what I was trying to do. ![]() |
#2
|
||||
|
||||
![]() Quote:
And, yes, you could create another look-up table for 'conditions' but I imagine there'd be so many variations compared to the number of patients that the effort in creating and maintaining it would outweigh the potential benefits.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel to lookup Access Database | PeterP | Excel | 1 | 06-11-2009 12:33 PM |
![]() |
tinkertron | Office | 5 | 03-29-2009 08:30 PM |
Excel or Access ? | inferno | Excel | 0 | 10-03-2008 03:42 AM |
Delete excel files by code in Access | Barry Richardson | Office | 0 | 06-13-2005 06:26 AM |
![]() |
Gregory_in_Montauk | Office | 6 | 05-06-2005 08:50 AM |