UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Unique Identifier, Office 2013    
 
   
bakersburg9
post Aug 12 2019, 01:02 PM
Post#1



Posts: 5,562
Joined: 2-November 04
From: Downey, CA


I asked a similar question regarding conditional formatting, but didn't solve that 'challenge' - so, pretty simple, I want create sequential ID #'s in column A, that change when the value in Column B changes - can't figure out the best way to do this, if it's doable - obviously, I can do something like
CODE
=B8=B7
, and copy down, but that just gives TRUE / FALSE any ideas ?
Attached File(s)
Attached File  ChangeIDfieldWhenValueInBChanges.png ( 13.58K )Number of downloads: 1
 
Go to the top of the page
 
ADezii
post Aug 12 2019, 01:18 PM
Post#2



Posts: 2,641
Joined: 4-February 07
From: USA, Florida, Delray Beach


If you change 'any' Value in Column B, then all the IDs must be recalculated?
Go to the top of the page
 
DanielPineault
post Aug 12 2019, 01:20 PM
Post#3


UtterAccess VIP
Posts: 6,854
Joined: 30-June 11



Not sure if this is what you're after, but check the attached.

And, am I wrong that your example has an error in it? The 1st entry for 9C7-54-08492 is 72, then the next entry is 73. Should it not remain 72?
Attached File(s)
Attached File  UA_Help_01.zip ( 6.17K )Number of downloads: 8
 

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
bakersburg9
post Aug 12 2019, 01:23 PM
Post#4



Posts: 5,562
Joined: 2-November 04
From: Downey, CA


Adez,
No, I did a poor job explaining - in the screen shot, the next ID would be 82, for 9G8-93-60471, on row 148,149 and 150 - since the value in col B changes with row 151, the ID for col A, row 151 would be 83, and so on and so on... so sequential numbers, changing when the value in column B changes...
Go to the top of the page
 
bakersburg9
post Aug 12 2019, 01:24 PM
Post#5



Posts: 5,562
Joined: 2-November 04
From: Downey, CA


Daniel,
Good catch - yes, you caught an error - thanks !!!
Go to the top of the page
 
bakersburg9
post Aug 12 2019, 01:31 PM
Post#6



Posts: 5,562
Joined: 2-November 04
From: Downey, CA


Daniel,

Wow, so simple, thanks !!! cool.gif I honestly would have never thought of that - thanks so much !!!!

Steve
Go to the top of the page
 
DanielPineault
post Aug 13 2019, 08:02 AM
Post#7


UtterAccess VIP
Posts: 6,854
Joined: 30-June 11



My pleasure. Glad I could help.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st September 2019 - 04:36 PM