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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by axemen
-
Need help to seperate odd and even numbers using queries
Thanks zerosandones, it works!!- axemen
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
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...- axemen
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
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...- axemen
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
