Recent content by DukeArgos

I'm using Access 2002 I have data contained "within" a field that i want to update. Example -- i have "," (a comma) that i want to change to ";" (semicolon). also i have " " (two spaces) that i want to change to " " (one space). data example: Doe, John -- i want this to be == Doe; John also...

i ended up getting this to work using Mile-O-Phile's original suggestion of a "newfield"... (at the time, i didn't exactly understand why i needed a newfield -- but now i do...) I couldn't get the sort to work in the report because it didn't seem to accept the clng function in the report. If...

Rich, I checked the sorting and grouping options and the report had already defaulted to sorting the same way as the query. I'm guessing this was already done because i used the wizard to initially create the report. I tried using the clng function in the report sorting and grouping options...

are you saying there are sorting options in the "report"? I was only using the "order by" in the sql query... how do i do a sort in a report? thanks for the help!!! :)

Hmmm, Now the query is working fine -- but when i create a "report" -- the report is changing the sorted order back to disregard the CLng function... I posted more details of the report problem in the report forum here...

I am trying to create a report based upon the following query: SELECT Structures.ADD_NUM, Structures.PREDIR, Structures.ST_NAME, Structures.ST_TYPE, Structures.NOTES, Structures.OADDRESS, Structures.OSPREFIX, Structures.OSNAME, Structures.OSTYPE, Structures.HOUSEHEAD, Structures.COMMUNITY FROM...

ahhhhhhhhhhh, with your help -- i think i figured it out.. SELECT Structures.ADD_NUM, Structures.PREDIR, Structures.ST_NAME, Structures.ST_TYPE, Structures.NOTES, Structures.OADDRESS, Structures.OSPREFIX, Structures.OSNAME, Structures.OSTYPE, Structures.HOUSEHEAD, Structures.COMMUNITY FROM...

Thanks again!!! I was able to follow what you suggested and copied and pasted the sql statement you provided and then I saw the changes that occured in the design view. However, i'm still not getting it sorted the way i was hoping. I'm getting the following results: 1 MAIN ST 11 MAIN...

Mile-O-Phile, Thanks for responding and trying to help me!!! :) ok, it's official -- i'm an idiot when it comes to this... i don't know how to implement what you suggested... here is the sql query i currently have generated from access using the query designer: SELECT Structures.ADD_NUM...

In access, i'm trying to sort a text field. 99.9% of the contents of all the records contained in the text field are numbers. I don't want to permanently make the field a number, i just want to sort it as if it were a number... Can anyone help me? thanks :)