tmetford
Thread Starter
- Joined
- Apr 8, 2008
- Messages
- 56
I know this is beginner level stuff, please be patient!
I want to create a Report that shows only one record for the purpose of writing a letter to a patient.
At the moment I seem to get lots of records showing (which is what a report is designed to do, I know) but it's not what I want.
I want to have a means to select a patient's last name, drawn from a Patient's table (may be I need to use a Select Query?) and have a report show this name in the manner you'd expect a business letter to be written.
I would then want to be able to add the text I want to say to that patient (may be using an unbound text box?) so that a letter can then be printed and mailed.
What steps do I take to design such a report?
I hope this is clear enough and, ultimately, I want to be able to have related data appear in this report which has been drawn from two other separate tables (i.e. Doctors table and Surgeries table).
I know I have to construct a query to do this but I need help with this too and with designing the database appropriately in the first place to help it all work!
Thank you for your help in anticipation.
Tim Metford
I want to create a Report that shows only one record for the purpose of writing a letter to a patient.
At the moment I seem to get lots of records showing (which is what a report is designed to do, I know) but it's not what I want.
I want to have a means to select a patient's last name, drawn from a Patient's table (may be I need to use a Select Query?) and have a report show this name in the manner you'd expect a business letter to be written.
I would then want to be able to add the text I want to say to that patient (may be using an unbound text box?) so that a letter can then be printed and mailed.
What steps do I take to design such a report?
I hope this is clear enough and, ultimately, I want to be able to have related data appear in this report which has been drawn from two other separate tables (i.e. Doctors table and Surgeries table).
I know I have to construct a query to do this but I need help with this too and with designing the database appropriately in the first place to help it all work!
Thank you for your help in anticipation.
Tim Metford