Automatic Numbering of Records. Renumber Counter on Add, Delete. Row Numbers in Microsoft Access.

[@mubeezimicah5678]

i just love the logic you used

[@599CD]

Thanks!

[@kurumbot]

Thanks a lot ! I used this using a query to count specific data. :)

[@599CD]

You're welcome

[@ራማፅዮን8617]

What a great solution for my work!

[@ZahidKhan-mb6oc]

Very useful and simple solution. Thanks a lot Richard. You are great....

[@599CD]

Many thanks!

[@smallwoodrh]

Nice video. Another interesting topic would be adding number logic to your auto numbers and how to reset auto numbers when testing your tables/database.

[@599CD]

You mean something like this: 599cd.com/counter And resetting your AutoNumbers is just a matter of compacting, but yes, always helps to mention that. Thanks!

[@AlaIsmail2012]

Thank you...your solution is simple and effective.

[@599CD]

Glad it helped

[@Ziahasan222]

Awesome... Great. Thanks you sir.

[@599CD]

Welcome

[@thesantosfamily]

Thank you!

[@jayd3578]

Thank you for doing that video.

[@599CD]

My pleasure!

[@sajidambar9425]

Very Nice !, Sir. Thanks

[@599CD]

Most welcome

[@lylebailey-sq2ek]

is this right =iff(IsNull([customerid]),Null,DCount("customerid","customert","customerid

[@599CD]

It's IIF, not IFF. Common mistake. And sure, you can use a query or a table for your form's record source.

[@69woogie]

Thanks for another great video. I have a question. when I used this on a sub form, subsequent form do not start at one. what have I done wrong?

[@599CD]

Can't tell without seeing it

[@aaliyah_expressions]

Hey @ComputerLearningZone Is there a way to keep count of how many times a client comes in when they have pre-paid for ex:5 sessions and restart after used I want it to be highlighted and or notify me. Or should I use Excel instead?

[@599CD]

If your needs are simple sure go ahead and use Excel. Once you outgrow that and you got hundreds of customers and it's hard keeping track of them in Excel then switch over to Access. Even I don't use Access for everything. But if you wanted to put this in Access just have a customer form and then on their order form track their visits and the order details perhaps. There's a million ways to do it. 599cd.com/qq

[@petervansoestdevrolijkeboe3320]

Is there a way to make this work when you don't display ALL the records in a table? Like in a query where you display a specific selection of the table but still want to number the output rows like 1, 2, etc..

[@599CD]

Sure you would just have to base the calculation on the query instead of the table directly. Post this question in the forum on my website and we can discuss it in more detail. I don't check KZbin comments that often.

[@petervansoestdevrolijkeboe3320]

@@599CD HI Richard, I did post it on the forum, but it was removed (by a moderator?) and I don't understand why

[@599CD]

Peter, I get emailed a copy of anything removed by a moderator, and I don't recall seeing that. Perhaps it was a glitch. Post it again and let me know when you do. [e-mail]

[@kurumbot]

@@599CD Thank You for this reminder. :) I forgot that I can also use this in a query. :)

[@suonvirakvichetra844]

Hello Computer Learning Zone, I use the formula to count from a query with custom sorting instead of a table. But it doesn't seem to show the number in the correct order. Can you please help me?! Thank you.

[@599CD]

I'm not a psychic. I can't fix what you've done without seeing it. :)

[@PAKITWORLD]

Sir i have one saleTbl and one customerTbl i want to create customer ledger with running balance...problem is that i have unique customer id ..but have same bill no. For example one customer is john and his bill no 1 ..socend customer is smith and his bill no 1 ...when i want to create a query of running balance its not work fine...please guide me sir

[@599CD]

Check Register: 599cd.com/CheckRegTH

[@justene9344]

Can you add these number to a table rather than a form? If so, how do you approach this?

[@599CD]

I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT

[@PAKITWORLD]

If i create query of running balance from one table then its work fine....but if i try one from one table that contain all customer then its problem

[@599CD]

OK

[@selvarajandiappa3143]

Hi Richard.. On numbering format can we set "YYMM-0000

[@599CD]

Sure!

[@amirhosseinrezaei4723]

Hi Richard I have some problem I use manual atomic number with " = Nz(Dmax("[ID]";"[Table_Name]");0)+1" this formula And error "Name# " please help me ............................. I have more problem more 2 years..............

[@599CD]

Use commas, not semicolons. At least in the English version.

[@hotwebs]

May I know, which part is having a problem, white hair is getting more xD Table Name: Item Tracing1 ID: Auto Number Box Number: Short Text I got Error below code: = IIf(IsNull([ID]),Null,Nz(DCount("ID","Item Tracing1","Box Number=" & [Box Number] & "AND ID

[@599CD]

Well, I see you're missing a space before the word AND.

[@sajad2126]

Hi, when i sort list Z to A row numbers get descending

[@599CD]

That sounds right

[@arul6975]

It was a fine video but your accent was too fast. sometimes it was not easy to understand.

[@599CD]

Well, that's just me, I guess. :)