M
MaRSMAN
My query returns selected records from a table. Works fine
How do I select only certain records from that query to add new records to
another table. That tables fields are:
caCommuned type yes/no checkbox need this to become check for true
caDate type Date/time Shortdate need this to be filled with a certain
date I select
casID type Number longinterger foreign key Need this to fill with the sID
The Select Query returns fields from table Souls
sID type autonumber primary key
sStauts type text sorted as
sCommunicant type yes/no checkbax criteria true
sLSName type text sorted as
sFMName type text sorted as
The above selected query will also be used to print a report at a later date.
I am new and do not know all the code yet.
The Lord's Blessings on your Day
Marsman
How do I select only certain records from that query to add new records to
another table. That tables fields are:
caCommuned type yes/no checkbox need this to become check for true
caDate type Date/time Shortdate need this to be filled with a certain
date I select
casID type Number longinterger foreign key Need this to fill with the sID
The Select Query returns fields from table Souls
sID type autonumber primary key
sStauts type text sorted as
sCommunicant type yes/no checkbax criteria true
sLSName type text sorted as
sFMName type text sorted as
The above selected query will also be used to print a report at a later date.
I am new and do not know all the code yet.
The Lord's Blessings on your Day
Marsman