Adding new record for each patient

[Nona]

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.

 

[John W. Vinson]

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.

 

[Nona]

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!

 

[John W. Vinson]

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.

 

[Nona]

Got it! Many many thanks!
--
Nona

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.