D
davedinger
I need to create and populate a new field in an exitsing
table I call Narratives. The field i need to create is
named Referral.
the existing data resides in another table called Referral
Information referral date.
I need to transfer the referral dates in to the new
Narritives table referral field so that I can see the
narratives that happined durring a referral period
The tables both have a common link of SSN#
The narrative table has a narrative [date] field, and my
Referral table has a [Referral Date] and a [date closed]
fields.
I need to have a query look at the Date the narrative
was made to see if it was between the referral information
referral date and the referral information date closed.
and if it is i need the query to fill the referral date
into the new field [referral date] in my narrativs table.
boy I hope that made sence
Please help
table I call Narratives. The field i need to create is
named Referral.
the existing data resides in another table called Referral
Information referral date.
I need to transfer the referral dates in to the new
Narritives table referral field so that I can see the
narratives that happined durring a referral period
The tables both have a common link of SSN#
The narrative table has a narrative [date] field, and my
Referral table has a [Referral Date] and a [date closed]
fields.
I need to have a query look at the Date the narrative
was made to see if it was between the referral information
referral date and the referral information date closed.
and if it is i need the query to fill the referral date
into the new field [referral date] in my narrativs table.
boy I hope that made sence
Please help