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 bkrike 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: AlienX69
  • Content: Threads
  • Order by date
  1. AlienX69

    Order By with Mid function NOT working ?

    First, I'm using MS Access as a READ ONLY Front-End to a Oracle dB via ODBC. I have a query that I cannot seem to figure out why it is not sorting correctly. Trying to sort the PATH_NAME field first, in particular the 8th thru 10th characters. So I thought I would try the "Mid" function. Also...
  2. AlienX69

    Shorten a Text Field via Query Expresion ?

    I have a text field that have a few records with a consistent string at the end, i.e. "....... Disk 1 of 4" or "...... Disk 1 of 3" Characters before the "Disk 1 of #" varies so the Left function will not work Thought of using "Mid", but don't think that will work either ? I would like to...
  3. AlienX69

    Problem with Format Function

    ######################################################### First, would like to say THANKS to all the GREAT support folks here for taking the time to help n00bs like me. ######################################################### Having a problem with the following in a qry: Total Pipe Length...
  4. AlienX69

    Importing .xls mins/secs (mm:ss) into MS Access

    What is 03:23 in Excel is being converted to "0.0023479861111" during the import into MS Access 2003. When trying to Import a Excel file containing a column where the format for ALL the cells in that column are Cat: "Custom" Type: mm:ss. When I step through the Import process and get to...

Part and Inventory Search

Back
Top