Hi, i want counting that starts from autonumber 0001/20015, 0005/2015, 0007/2015, 0009/2015, 0011/2015, 0015/2015, but during counting eliminate: 0003/2015, 0013/2015, 0023/2015
Hi, i want counting that starts from autonumber 0001/20015, 0005/2015, 0007/2015, 0009/2015, 0011/2015, 0015/2015, but during counting eliminate: 0003/2015, 0013/2015, 0023/2015
Are you saying you have a table with a field populated with a string (0005/2015 is not an autonumber) and you want to count the records in the table where the 4th digit in this string is not a 3?
Have you tried highlighting the field and using the Backspace key on your keyboard?
Basic relational table design --1 fact, 1 field.
I'm not sure how you got to where you are, but in my view you are starting on the wrong track.
Suggest you get a clear description of what you are trying to do. Design your database using rules of normalzation.
Getting the tables and relationships designed to meet your business requirements is critical to maintainable and useful database.
Good luck with your project.
your query would have the following criteria
where instr(id,"3/")=0