Results 1 to 6 of 6
  1. #1
    pllummix is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2015
    Posts
    2

    Counting autonumber ???


    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

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    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?

  3. #3
    pllummix is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2015
    Posts
    2
    How to exclude (eliminate) these numbers in picClick image for larger version. 

Name:	ty.jpg 
Views:	12 
Size:	73.1 KB 
ID:	21156

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Have you tried highlighting the field and using the Backspace key on your keyboard?

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    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.

  6. #6
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    your query would have the following criteria

    where instr(id,"3/")=0

Please reply to this thread with any new information or opinions.

Similar Threads

  1. autonumber
    By kelvinkind in forum Access
    Replies: 1
    Last Post: 06-26-2014, 10:24 PM
  2. Replies: 4
    Last Post: 11-21-2013, 05:06 PM
  3. Autonumber changes
    By wizardnick in forum Access
    Replies: 5
    Last Post: 09-22-2013, 08:58 AM
  4. Replies: 2
    Last Post: 01-15-2013, 10:04 PM
  5. Help with autonumber
    By GDubbs780 in forum Programming
    Replies: 15
    Last Post: 02-27-2011, 02:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums