I'm working on a database for a group in a Police Department, I would rather make this as easy as possible. Is there any way to do this automatically so that the user doesn't have to click anything?
I'm not really all that familiar with Access, but I need to create a report ID that is separate from the unique ID. I just got thrown into this project and I've been able to wing my way through most of it. I can get it to display the correct value via
"=Format(Date(),"yymm") &...