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!

Search results for query: *

  • Users: law32908
  • Content: Threads
  • Order by date
  1. law32908

    Client has dates in text field - help to compare?

    I have this client who's database was sloppily set up. They have asked me to do several queries - based on a text field that has a date in it - called ProcessNum. Example ProcessNum: 0803011503 Stands for 08/03/01 - time 15:03. As I said, this is in a text field. I have tried everything...
  2. law32908

    IIF Query Problem

    Hello all, this is my first question. Thanks in advance for any help you can provide. I have a statement in a query that should read like this: If Warn8=Yes, then (Full*AWP)+(9Percent/100)*AWP))+((AWP/Packagesize)*Exact)) If Warn8=No, then...

Part and Inventory Search

Back
Top