5 replies
by parier
Yes. I would start by writing a query to create a table/xls doc that will include all the fields and data you want to see. Once this is created, this will be your data source.
So, if patient A has 10 medications, you should have 10 records for him/her. AND the required information should be there 10 times, first name, last name, address, patient ID#, etc) Duplicate values such as these can be filtered using excel.
Once the data source is created as XLS, I would personally use Access, since you can write your query and interface your main data source and streamline the whole process. For example, users would open Access, click on a button, then the "make table" option would automatically create the query, insert these records to a new or update an existing table, then open the report which would be formatted for the desired results from a joined query and have patients name, info and only their medications per page...along with any other information you may need contained in existing tables and included in the join.
It?s not as scary as it seems, just itemize each step and move forward to get something, then since Access is easy to modify once created, you can beef it up later and include more tables, fields as required.
Hope this helps.
-E
by jillm
Thanks, but this didn't answer my question. The Access database table is already created. It's the Word field I needed help with. I appreciate your taking the time to respond, though. That was a good response. Sorry I didn't make it clearer that it is the Word side of things I need help with.
by chavdaraju
The best way to solve this problem is,
Create a query and use it in MS Word mail merge.
by jillm
Poster rated this answer.
by jillm
This discussion is closed to new replies.
Trending Software posts
Sort by Trending