Search results

Thanks Janr, your suggestion looks like simple and I will try it soon !! Bye Giovanni

Dear all, I did a query which update a sequence number (column NR_SEQUENZA) in a table using a nice code (from Trevor !). 1) Given that I'm not a programmer I can't understand why numbering doesn't start always, running more times the update query, from the same starting parameter assigned...

Why I need to do so ? The end user would like to check data and relative formatting before to send the query result to regional office so that he/she can edit the original table or to re-do all the uploading process. The easiest way to simulate the result is something like I'm doing. Bye Giovanni

Ok now it works !! Thanks again Espr1: Str([STRUEROG]) & String(8-Len([STRUEROG]);" ") Bye Giovanni

Thanks so much for suggestion ! I did what you said but MsAccess 2003 give me #Error when I run it. Espr1: [STRUEROG] & String(" ";8-Len([STRUEROG])) Have you got idea what it could be ? Thanks Giovanni

Dear All, I'm trying to build a query that has to add blanks to a field value content to fill all the field fixed lenght. I.e. Fixed field lenght = 8 Field content "ABNN" result "ABNN " Field content "AB" result "AB " and so on. I did the following but it doesn't work ...