Search results

Thanks everyone for your help. It is now sorting in order. The numbers were originally an AutoNumber but I had problems displaying them. So I converted them to a string when I requested them in a query. Someone pointed out that I could just convert them to an int which worked. I thought an...

no that doesnt seem to work...

Hi I have a report that lists a series of numbers. Due to a problem that i wont go into here, i have had to convert those numbers to strings before placing them on the report. Now i have a new problem! It orders the numbers by the first digit. Thus i get something like: 1 10 11 12 13 3 33 4...

if u r interested, in the queries i converted the autonumber to a text field: Exp1: Str$(refnum) and that did the trick! YAY! now i have to find myself something to do tomorrow!

Hi Rich No, the Can Shrink property thing didn’t work. I might change the RefNum from an AutoNumber to an integer and have a bit of code that makes sure whatever is entered hasn’t been used before.... Theoretically no records should be deleted as they would not become redundant (it is a...

thanks for the depressing news Rich! I dont think i will be able to learne to love them. especially as the user can define a period the report it to be based upon, so down the track the report will end up being a couple of blank pages and then one page of data! If you get what i mean.. Back to...

sorry my example report didnt display as i thought it would....

Hi I have been pondering this problem for a while and the resident access expert in the IT department has told me it isn’t possible. I have built this database and now want the user to be able to print a statistic report. Each record has a unique AutoNumber called ‘RefNum’. The problem stems...