Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904

    You are welcome!

  2. #17
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You had sent an email asking for a fourth option, to include 6's also. That code would look like:
    Code:
    SELECT GNumbers.Numbers
    FROM GNumbers
    WHERE (((Left([Numbers],Len([Numbers])-1)) In (SELECT Left([Numbers],Len([Numbers])-1) AS Prefix
    FROM GNumbers
    GROUP BY Left([Numbers],Len([Numbers])-1)
    HAVING (((Sum(IIf(Right([Numbers],1)=5,1,0)))>0)  AND ((Sum(IIf(Right([Numbers],1)=6,1,0)))>0) AND ((Sum(IIf(Right([Numbers],1)=7,1,0)))>0) AND ((Sum(IIf(Right([Numbers],1)=9,1,0)))>0)))) AND ((Right([Numbers],1)) In (5,6,7,9)));
    I highlighted in red what I added for the 6's.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 04-04-2016, 04:08 PM
  2. Sequentially Numbered Column
    By DMullane in forum Access
    Replies: 1
    Last Post: 12-09-2014, 01:50 PM
  3. Adding sequentially
    By Thompyt in forum Programming
    Replies: 13
    Last Post: 11-21-2014, 10:55 AM
  4. Making Access display records sequentially
    By louislinti in forum Access
    Replies: 1
    Last Post: 10-05-2013, 04:49 PM
  5. Sequentially number records in a table field
    By kenton.l.sparks@gmail.com in forum Programming
    Replies: 4
    Last Post: 04-08-2011, 08:24 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