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 Chriss Miller 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: *
- Users: BlackBox95
- Order by date
-
Help needed on query sort - IIf?
Simply sorting by SN would work in my example above, but I guess I oversimplified my example for clarity. The actual serial numbers that i am working with are vehicle VIN#s and other similar strings. They all have 10 to 17 digits and contain both letters and numbers so they must be a text field...- BlackBox95
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Help needed on query sort - IIf?
Ok, too keep things simple ill make up a simple scenario: Table1 has 5 fields: ID(autonumber),Year(number),SerialNumber(text), Description (text) Table1 has 9 records: ID Yr SN Descr 8 2001 00001 testdescription1 1 2002 00002 testdescription2 6 2003 00003...- BlackBox95
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Help needed on query sort - IIf?
Hello all, I have an .mdb that keeps track of construction Equipment and vehicle inventory. I am trying to come up with a query that will sort the items by age (newest to oldest)and/or by serial number (newest to oldest). My problem occurs when i recieve an inventory listing that does not...- BlackBox95
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
