Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: MemberID and resetting its Count on April 1st


Message #1 by "John" <lastword@n...> on Fri, 30 Nov 2001 11:32:45 -0000
This is a multi-part message in MIME format.



------=_NextPart_000_0012_01C17992.BB1ADAD0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Hello, I have been making a database system for my golf shop manager and 

so far the template for member entry that came with Access has been good 

enough. My only problem since updating it, is placing the Memeber ID on 

the report (which works) but resetting it upon reaching April 1st. I 

don't want to lose any records associated with the MemberID, so I 

thought I must need a count running alongside. Can someone point me in 

the correct direction in making a validation rule which will reset a 

count on April 1st, and start incrementing again upon adding new records 

to the members table.



Thanks, first time posting to this board. Hopefully the last time too. 

:)







  Return to Index