Thanks a lot ! I used this using a query to count specific data. :)
@599CD6 ай бұрын
You're welcome
@Ramawit86177 ай бұрын
What a great solution for my work!
@mubeezimicah56783 жыл бұрын
i just love the logic you used
@599CD3 жыл бұрын
Thanks!
@ZahidKhan-mb6oc3 жыл бұрын
Very useful and simple solution. Thanks a lot Richard. You are great....
@599CD3 жыл бұрын
Many thanks!
@thesantosfamily3 ай бұрын
Thank you!
@AlaIsmail20123 жыл бұрын
Thank you...your solution is simple and effective.
@599CD3 жыл бұрын
Glad it helped
@smallwoodrh3 жыл бұрын
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.
@599CD3 жыл бұрын
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!
@lylebailey-sq2ek3 жыл бұрын
is this right =iff(IsNull([customerid]),Null,DCount("customerid","customert","customerid
@599CD3 жыл бұрын
It's IIF, not IFF. Common mistake. And sure, you can use a query or a table for your form's record source.
@Ziahasan222 Жыл бұрын
Awesome... Great. Thanks you sir.
@599CD Жыл бұрын
Welcome
@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. amicron@gmail.com
@kurumbot7 ай бұрын
@@599CD Thank You for this reminder. :) I forgot that I can also use this in a query. :)
@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
@jayd35783 жыл бұрын
Thank you for doing that video.
@599CD3 жыл бұрын
My pleasure!
@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
@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
@suonvirakvichetra8442 жыл бұрын
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.
@599CD2 жыл бұрын
I'm not a psychic. I can't fix what you've done without seeing it. :)
@sajidambar94253 жыл бұрын
Very Nice !, Sir. Thanks
@599CD3 жыл бұрын
Most welcome
@69woogie2 жыл бұрын
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?
@599CD2 жыл бұрын
Can't tell without seeing it
@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
@amirhosseinrezaei47233 жыл бұрын
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..............
@599CD3 жыл бұрын
Use commas, not semicolons. At least in the English version.
@selvarajandiappa31432 жыл бұрын
Hi Richard.. On numbering format can we set "YYMM-0000
@599CD2 жыл бұрын
Sure!
@sajad21263 жыл бұрын
Hi, when i sort list Z to A row numbers get descending
@599CD3 жыл бұрын
That sounds right
@hotwebs2 жыл бұрын
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
@599CD2 жыл бұрын
Well, I see you're missing a space before the word AND.
@arul6975 Жыл бұрын
It was a fine video but your accent was too fast. sometimes it was not easy to understand.