Jump to content

Adding a new year


tbcomputerguy

This topic is 3090 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello again, long time since I visited. I have setup a curling membership database to record all pertenant info; being which league, the team they are on, team position etc. But now I want to create a new years worth of data. I thought about this at its inception but time got the better of me and I negelected it. My thoughts were that I create a new year table, then create a new record in that table. then, when I create new team or member have it populate a current year field in the respective tables with the value of the current year. or curryr_ID. This way when a new record is created, it will have that ID attached to it. Follow me?

Link to comment
Share on other sites

If I'm understanding the original question, if the desired result is to auto-enter the current year:

Year( Get(CurrentDate) )

OTOH if the year number you need is not always the current one then the approach you described makes a little more sense.

Link to comment
Share on other sites

This topic is 3090 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.