I have a database that lists our clubs. Some have changed their name
over the years. The recorded fields are;
Current name of the club: ClubName
Previous name of the club: Formerly
Date that the name changed: ChangeDate
Date that member joined the club: DateJoinedThisClub
I am attempting to build a history of the members in each club. I
have written this code that is supposed to fill the new field "Club"
with the name of the club at the time the member joined.
Club: IIf([DateJoinedThisClub]<[ChangeDate],[ClubName],[Formerly])
It does show the previous club but does not show the current club.
What have I missed?
Many thanks,
Robin Chapple
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar