Basic Report Noobie Question

[NSmoller]

I'm an employee of a healthsystems organization.

we have a list like follows:

Dr Smoller Johnson, Gary Lipitor 10 mg 2/10/05 ...
Dr Smoller Smith, Tony Lipitor 20 mg 12/10/05...
Dr Smoller Robinson, Wendy Lipitor 10 mg 1/3/06...
Dr Stenzo Doe, Jane Lipitor 20 mg 3/10/05...
Dr Stenzo Marie, April Lipitor 20 mg 1/24/06...

So we have a query containing patient's last refill of a prescription by provider.

We want to send individual letters to each Dr with the LIST of their patients in it.

How do i accomplish this? mail merge? access report? HELP! thanks!

 

[mp9]

If you want to do it in an Access report you need to group by the doctor ID info and put that in a group header on the report.

Then in the Properties of that group header set the Force New Page property to Before Section.

http://www22.brinkster.com/accessory/

 

[AlexMidd]

You could use a report with the DoctorName field in the Grouping and Sorting box and a Group Header selected for that field. Place the DoctorName textbox in that header and the patient-specific fields in the detail section.

Have fun! )

Alex Middleton

 

[NSmoller]

thank you so much works wonderfully.

if i may ask another question. One of my columns has a numeric value 1, 2, or is null. Can i make these astericks?

 

[AlexMidd]

Do you mean make it an asterisk if the value is null?

Have fun! )

Alex Middleton

 

[NSmoller]

i mean make the value an asterick if it is 1 or 2.

I also dont want the column name to display on my report

 

[AlexMidd]

=IIf(not isnull([YourField]),"*","") (I think)

Have fun! )

Alex Middleton

 

[NSmoller]

ya i figured something like that, but where does it go?

 

[NSmoller]

one more... can i save a report as a template??? how? i'm so new to this stuff

 

[AlexMidd]

First question: in the ControlSource property of the textbox.
Second question: I don't think so.

Have fun! )

Alex Middleton