M
msnews.microsoft.com
I have a database that I am importing periodically from DOS Foxbase. I need
to make changes in Access.
Several fields are using codes for accented characters such as o' for ó, o;
for ö, u" for u
Replace works fine, but I would like to automate the process. I know it is a
one line code, but I don't have the time to figure it out (to learn access
programming for that one task)
I also have a field with a code, 26 to be exact. I want them in a non
alphabetical order, so I would like to replace for example 'A' with 06, 'B'
with 12 so that I can determine the order for reporting. (The database is a
book catalogue, the codes are subject headings with one letter mnemonic
codes such as 'L' for literature and the printed catalogue needs to be in a
logical, not alphabetical order)
There should be a better way than to write 26 replace queries. I could not
figure out how to do it with one. Can i strind queries together in a macro?
Where can I find some sample that can show me how to do these simple tasks?
Any help would be greatly appreciated
Zork Hun
www.trixnet.com
to make changes in Access.
Several fields are using codes for accented characters such as o' for ó, o;
for ö, u" for u
Replace works fine, but I would like to automate the process. I know it is a
one line code, but I don't have the time to figure it out (to learn access
programming for that one task)
I also have a field with a code, 26 to be exact. I want them in a non
alphabetical order, so I would like to replace for example 'A' with 06, 'B'
with 12 so that I can determine the order for reporting. (The database is a
book catalogue, the codes are subject headings with one letter mnemonic
codes such as 'L' for literature and the printed catalogue needs to be in a
logical, not alphabetical order)
There should be a better way than to write 26 replace queries. I could not
figure out how to do it with one. Can i strind queries together in a macro?
Where can I find some sample that can show me how to do these simple tasks?
Any help would be greatly appreciated
Zork Hun
www.trixnet.com