D
Dave Engel
I have 2 Tables one called Narratives the other called
Referrals. After several months of use I now realize that
I need to have the date of the referral attached to each
record in the narrative table.
how can I make a new field in the Narratives table fill in
data based on a statement from records that exist in the
Referral table?
The common Link for both tables is a SSN#
There are several referrals per SSN#
There are several narratives per referral
The Narrative all have a Date Created
The Referrals all have a Date Open and have a date closed
I have found that I can create a query with the SSN#'s
linked from both tables. And I created a field in the
query that will look at the date the narrative was created
and compair to see if it is between the Referral Open and
Referral Closed if it is then input the Referral date if
it is not enter "". However I cant get the data to copy to
the right records in the Narrative table like I need. Any
Ideas?
Referrals. After several months of use I now realize that
I need to have the date of the referral attached to each
record in the narrative table.
how can I make a new field in the Narratives table fill in
data based on a statement from records that exist in the
Referral table?
The common Link for both tables is a SSN#
There are several referrals per SSN#
There are several narratives per referral
The Narrative all have a Date Created
The Referrals all have a Date Open and have a date closed
I have found that I can create a query with the SSN#'s
linked from both tables. And I created a field in the
query that will look at the date the narrative was created
and compair to see if it is between the Referral Open and
Referral Closed if it is then input the Referral date if
it is not enter "". However I cant get the data to copy to
the right records in the Narrative table like I need. Any
Ideas?