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 law32908
-
Client has dates in text field - help to compare?
Thanks, Darrylle. I should have been more clear on what I did! I tried changing the date format of the table - with all different kinds of formats (sort of a trial and error) I tried creating a new table with the right format and appending the data to it with a query. I tried inserting...- law32908
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
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...- law32908
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
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...- law32908
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
