Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    hockeyman9474 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2013
    Location
    Manalapan, NJ
    Posts
    45
    I think using the * is perfect. If the Street Name 123 Anywhere Street and I use *Anywhere Street then the code will compare to any data in the table that ends in Anywhere Street, no matter what comes before it. The only downside is if the user types Anywhere Street compared to St. correct?



    Now that I understand what is going on let me code and see if i get it to work. I'll let you know. Great Lesson and thank you.

  2. #17
    hockeyman9474 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2013
    Location
    Manalapan, NJ
    Posts
    45
    Success. I accomplished my goal for the day and learned a whole lot at the same time. I used to work in Access and now I work in SQL, but never the two two did I mix until today. I don't know your real name but mine is Adam and I sincerely thank you for your time and patience.

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

Similar Threads

  1. Query with Counter from multiple tables
    By dmenger in forum Queries
    Replies: 3
    Last Post: 03-25-2014, 11:07 PM
  2. Query: Add 'Subset' counter to records
    By JangLang in forum Access
    Replies: 1
    Last Post: 09-20-2013, 10:51 AM
  3. Counter Query for Maintenance
    By theperson in forum Queries
    Replies: 3
    Last Post: 10-23-2012, 05:17 PM
  4. Counter
    By Skroof in forum Access
    Replies: 3
    Last Post: 05-14-2012, 08:25 AM
  5. Incrementing Counter in Query
    By Rawb in forum Queries
    Replies: 9
    Last Post: 02-10-2011, 02:58 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