Recent content by kencpeck

We figured it out. Thanks anyways guys! :D

Hello, I have a query and in one of the fields contain the following, tot:(([Putaway]+[Replen]+[Wrong Loc]+[Receiv/Load]+[Mixed]+[Damage])*2)+(([Leftoff]+[Keying]+[Process Error])*8)+(([Mispick]+[Old Pt Values])*5)+([Adjust]*8)+([Misc]*1)+([1Pt Value]*1)+([2Pt Value]*2)+([3Pt Value]*3)+([4Pt...

Thank! I think it's working! Will this reset to 1 every year? ex: 18-001?

I have a table that has ID's in them with the format of YY-NUM. Every time the year changes the ID is to go back to 1. I was wondering if it's possible to have this field add 1 to the NUM and keep track of the year. My other option was going to have the year and the ID in two separate fields...