Is there a way to add a new record with values for specified fields for
every patient in the database that meets certain criteria?

For instance, for every patient who has a funding source of 90056, I'd like
to add a record that would give the field called Units a value of "12" and
the field called Status a value of "Approved."

Thanks for your help with this.
--
Nona

On Wed, 5 Nov 2008 16:35:02 -0800, Nona <(E-Mail Removed)>
wrote:

>Is there a way to add a new record with values for specified fields for
>every patient in the database that meets certain criteria?
>
>For instance, for every patient who has a funding source of 90056, I'd like
>to add a record that would give the field called Units a value of "12" and
>the field called Status a value of "Approved."
>
>Thanks for your help with this.

An Append query would do the job. You don't post any details of your table
structure and you don't say which table contains the funding source and which
table should get the new records, so I can't be specific, but base an append
query on the table containing the funding source (with a criterion of 90056),
and append to the new table, appending a literal 12 into the Units field.
--

John W. Vinson [MVP]

I just don't know enough to follow your instructions. I can't get this to
work.

The funding source is in the Patient table. The fields for units and status
field are in a table called Authorizations.

The append query has the "append to" line for the table (Authorizations) and
a "criteria "line. But where do I enter the literal 12?

Or am I just way off-base? (I'm feeling very stupid tonight!)

Thanks for your patience!





--
Nona


"John W. Vinson" wrote:

> On Wed, 5 Nov 2008 16:35:02 -0800, Nona <(E-Mail Removed)>
> wrote:
>
> >Is there a way to add a new record with values for specified fields for
> >every patient in the database that meets certain criteria?
> >
> >For instance, for every patient who has a funding source of 90056, I'd like
> >to add a record that would give the field called Units a value of "12" and
> >the field called Status a value of "Approved."
> >
> >Thanks for your help with this.
>
> An Append query would do the job. You don't post any details of your table
> structure and you don't say which table contains the funding source and which
> table should get the new records, so I can't be specific, but base an append
> query on the table containing the funding source (with a criterion of 90056),
> and append to the new table, appending a literal 12 into the Units field.
> --
>
> John W. Vinson [MVP]
>

On Wed, 5 Nov 2008 20:23:01 -0800, Nona <(E-Mail Removed)>
wrote:

>I just don't know enough to follow your instructions. I can't get this to
>work.
>
>The funding source is in the Patient table. The fields for units and status
>field are in a table called Authorizations.
>
>The append query has the "append to" line for the table (Authorizations) and
>a "criteria "line. But where do I enter the literal 12?
>
>Or am I just way off-base? (I'm feeling very stupid tonight!)
>
>Thanks for your patience!

Just put the literal 12 in a vacant Field cell (prefixed by a fieldname if you
like, Access will call it Expr1 if you don't). Append this field to the Status
field in Authorizations.
--

John W. Vinson [MVP]

Got it! Many many thanks!
--
Nona


"John W. Vinson" wrote:

> On Wed, 5 Nov 2008 20:23:01 -0800, Nona <(E-Mail Removed)>
> wrote:
>
> >I just don't know enough to follow your instructions. I can't get this to
> >work.
> >
> >The funding source is in the Patient table. The fields for units and status
> >field are in a table called Authorizations.
> >
> >The append query has the "append to" line for the table (Authorizations) and
> >a "criteria "line. But where do I enter the literal 12?
> >
> >Or am I just way off-base? (I'm feeling very stupid tonight!)
> >
> >Thanks for your patience!
>
> Just put the literal 12 in a vacant Field cell (prefixed by a fieldname if you
> like, Access will call it Expr1 if you don't). Append this field to the Status
> field in Authorizations.
> --
>
> John W. Vinson [MVP]
>