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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.