list box items

From: Russ (Russ_at_discussions.microsoft.com)
Date: 03/06/05 

Date: Sat, 5 Mar 2005 18:07:03 -0800

I have a list box in a form. the list box is unbound. it displays a list of
medications for a patient. 2 tables are involved. the first table is
demographics, which the SSN comes from. teh second table has SSN and the
medication. the second table has several records for each patient, one
record for each medication.

i can get all the medications into the list box in teh form. but i now need
to put these all into one field of a query or table so that i can use them in
a mail merge with word. i must use mail merge so i can send a letter to
referring physician. how do i get these into one field. i would like them
all to be seperated by commas if possible.

thank you,
russ 

-- 
Russ

Relevant Pages

  • Re: An Alternate Pain Agreement
    ... I recently posted an article about pain contracts here, ... allow little in the way of rights or autonomy for the patient. ... agree to provide opiate medications for my employer (hereafter known as ...
    (alt.support.chronic-pain)
  • Re: An Alternate Pain Agreement
    ... I recently posted an article about pain contracts here, ... allow little in the way of rights or autonomy for the patient. ... agree to provide opiate medications for my employer (hereafter known as ...
    (alt.support.chronic-pain)
  • Re: Creating a form desgn to capture newborn visits
    ... medical records regulations governing what and how medical ... single patient, you don't need the many-to-many resolver table in your ... medications etc ... forms popping up to complete each exam can be confusing and require lots ...
    (microsoft.public.access.forms)
  • An Alternate Pain Agreement
    ... An Alternate Pain Agreement ... I recently posted an article about pain contracts here, ... allow little in the way of rights or autonomy for the patient. ... agree to provide opiate medications for my employer (hereafter known as ...
    (alt.support.chronic-pain)
  • Re: New database
    ... simple non patient related databases that have helped out our department ... could I just have one therapy table and include ... other reason is that the therapys all have medications with them, ... PtVentThpyEndDate ...
    (microsoft.public.access.tablesdbdesign)
Loading