A Serial Number Which Automatically Resets Every Day

[yameen.malix]

Regards,
I am working on a database,
structure of database tblaccounts: glcode,description.
tbltransaction: transaction ID, glcod, tranxtype, amount, trandate


Everything is going well, when i make a transc ,transcid genrated

i,e 1,2,3,to 47,48,49,50 and so on. In this case there are minimum 50 transaction on daily bases,
Here i have an idea that daily after 11.59pm ,i mean after changing date ,when i make a transction, transction id or sequence no start from 1, and my last day data will also remain safe .


This is what I am trying to accomplish I need to be able to create a serial number which automatically resets every day so I may use it to easily know how many records were created per day, without running a report., any Idea .help will be appreciated .

[June7]

Custom unique ID is common topic. Search forum. Here is one: https://www.accessforums.net/forms/n...lly-41161.html

[orange]

yameen

Why would you want to do that? I'm not saying you can't, I'm just curious as to why?
You will find many things easier with database if you design tables with atomic fields. If you want a date add a Date field, or Date and Time. Just suggesting things are easier and make life simpler with 1 fact 1 field.

Good luck with your project.

[yameen.malix]

Regards,
I may use it to easily know how many records were created per day, without running a report.,.

I am quoting my self, i have asked before that i want to know how many records were created per day, without running a report.
Dear Orange , I am working in a bank (UBL) , when i make a transaction in our (Bank) system a document number generated in our system against that transaction, and after day end , each day when we make our first transaction the document no start from 1, i mean document no rest daily after 12:00pm , and i want to Apply that technique in my database (if it is possible in Ms Access). i think you understand.
I am using transaction id as a auto number, but transaction id is increasing day by day, for this reason i want another counter for my database that will rest after a day.
Regards....

[ItsMe]

Why would you not be able to use a query? That is like saying you want to travel on the freeway without a vehicle. Include a timestamp (somewhere) and create a query. I guess you could use a domain function. That might fall within your prerequisite.

[June7]

A record count for the current day's records can be calculated on form much more easily than generating unique identifier. Add date/time stamp field ItsMe suggested.

[orange]

I suggest you get some basic training in database principles and table design.
I agree with ItsMe you have a poor/mixed-up understanding of databases, queries.....

I'll make a different analogy --suppose someone said "Yameen, you want to fly this airplane?
Would you jump in to the pilot's seat and hope for the best, or would you consider some training in the basics of piloting?