> One of the main things I need to learn is how to keep records of new and
> renewing members each year. At the moment, records for individuals are
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12564-there-character-limitation-200-characters-per.html
> written over with new date data each time a member renews. We really need
> record of when people renewed their membership each year. Does this kind
> function exist in Access? If so, can you please let me know the name of
> function and whether it is easy to set up? Please let me know if I need
> describe this query better.
There is not a particular function or feature that does what you want.
However, ms-access is most certainly capable of keeping a history of past
renewal information. It is much like question:
I have a hammer, will you please show me how the hammer can build a
Well, a hammer is most certainly used in building a house, but you have to
have a house design BEFORE you start using the hammer.
So, building a house, or a office table is not a particular "feature" of a
hammer, but a hammer can most certainly build both.
So, what you need is to sit down, and consider what historic information you
want to keep. The key to making ms-access (or a hammer) work is to have a
understating of the task at hand, and then learn how to "model" your data.
In ms-access, we use the concept of data modeling to "solve" your types of
problems (likely, you would consider a history table that is RELATED to the
main contact/customer table).
A sample template for memberships can be found at Microsoft's site http://office.microsoft.com/en-us/re...ery=membershipReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12564
In addition, a design for people involved in multiple memberships can be
found here: http://www.databaseanswers.org/data_...ents/index.htm
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com http://www.members.shaw.ca/AlbertKallal