Search results
-
D
Update Query Question
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... -
D
Report ? (based upon query with CLng sort function)
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... -
D
How to query and Sort a text field as a number field
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 :)