Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. axemen

    Need help to seperate odd and even numbers using queries

    Thanks zerosandones, it works!!
  2. axemen

    Need help to seperate odd and even numbers using queries

    Hi, There are 3 fields in this table: District, Street_no and Street_name, here is an example of the data: 1,2,4,5,7,8,9,10,11,12,13,15,18 Commercial St. District 9 2,4,6,8,12,16,20,24,28,30 Bay St. District 9 1,3,5,7,9,15,19 Bay St. District 8 33,37,39,45,47,51 Church St...
  3. axemen

    Need help to seperate odd and even numbers using queries

    Hi, I have a table containing street_no and street_name, I need to do a query and find out what type of numbers are there in a street_name. For example: Commercial St. contains both odd and even numbers, i have to create another field in the query making it to show mixed, and if Commercial St...

Part and Inventory Search

Back
Top