N
Nona
Is there a way to automatically add a record to a table for each person who
meets certain criteria?
The authorizations table I am working with has about 4,000 records. It holds
data about medical services for about 400 patients. The patient names and
other personal data are in a separate table.
For each of the patients who meet certain criteria (county, funding source,
etc.) I want to add a new record in the authorization table that has the same
information for each record - starting date of 1/1/09, ending date of
12/31/09, service code number, number of approved units of service.
It can't be an update query, because I want new records added to the table,
not update current records. It can't be an append query because I am not
appending records from another table or another database.
Is there a simple way to accomplish this?
I am using Access 2003 and will appreciate your help! My friends don't want
to have to enter each of these new records manually!
meets certain criteria?
The authorizations table I am working with has about 4,000 records. It holds
data about medical services for about 400 patients. The patient names and
other personal data are in a separate table.
For each of the patients who meet certain criteria (county, funding source,
etc.) I want to add a new record in the authorization table that has the same
information for each record - starting date of 1/1/09, ending date of
12/31/09, service code number, number of approved units of service.
It can't be an update query, because I want new records added to the table,
not update current records. It can't be an append query because I am not
appending records from another table or another database.
Is there a simple way to accomplish this?
I am using Access 2003 and will appreciate your help! My friends don't want
to have to enter each of these new records manually!