Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2016, 09:49 AM
mrsevilbrooks mrsevilbrooks is offline Auto insert year only Windows 10 Auto insert year only Office 2016
Novice
 
Join Date: Dec 2016
Posts: 2
mrsevilbrooks is on a distinguished road
Default Still confused


I'm a real newby to this version of Access (2016). I want to make an automatically incremental file number for each of my records. I want this format: YY-000-A. How do I get that both in a table and in my reports? Right now I have it split into 3 different fields. Is there a way to put it all in the same field? If not, how to I make the table field/report field just give me the two number year automatically? Thanks.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to calculate Leap Year USAOz Excel 2 09-11-2011 04:58 PM
Creative Ways for a year-to-year comparison??? ridonkulous5 Excel 1 03-23-2011 04:49 PM
Auto insert year only Year janak Excel 6 12-12-2010 10:08 PM
Form auto insert DaveC Word 4 06-20-2010 04:14 AM
Auto insert year only Auto insert current month's name and current year Styler001 Word 4 01-25-2010 06:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft