Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
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
 



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 02:07 PM.


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