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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sql Max returning lowest -Negative as Max
Looks like it's comparing strings, not numbers. If you want to do a one-time update to increase the number of digits, what about UPDATE Invoices SET InvoiceID = MID(InvoiceID, 1, InStrRev(InvoiceID, "-")) & RIGHT("00000000" & MID(InvoiceID, InStrRev(InvoiceID, "-") + 1), 5) where the last...- sqlmaniac
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
access macro continue on error
Make sure the Break on All Errors option is off (Tools->Options->General tab) http://support.microsoft.com/kb/209884- sqlmaniac
- Post #5
- Forum: Microsoft: Access Other topics
