URGENT: Query field mistake

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sirs,
My program is ready thanks and due to all of your help.
During testing now I realized that I have a field in a query which is
called:openp & l
but it should be called openp&l (without any spaces). Unfortunatelly this
field carries through nearly the whole program.
I realized it because I created my ASP on that, and with spaces it doesn't
work.
Can someone tell me how I can easily correct this mistake so that, for
example, I type it in once correct and all fields using this are getting
changed automatically.
Thanks
Klaus
I forgot to mention that the first time this field is used in a in a query
it is
to calculate a total. I tried to change the field but I cannot save it to the
"non space" writing. It always goes back to the initial writing.
 
Can someone tell me how I can easily correct this mistake so that, for
example, I type it in once correct and all fields using this are getting
changed automatically.
Click to expand...

I would strongly recommend that you should NOT use an ampersand in a
fieldname. Access treats the ampersand (&) as an operator - for
concatenating strings - in SQL and in VBA code; in labels, it causes
the next character to be displayed underlined and to work as a hotkey.

You can use one of these programs to do a global replace:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com


John W. Vinson[MVP]
 
I have a similar problem, except this is a linked databse table and there's
only one query I need to write. Field name is 'S&H' (honest!)
 
There are a couple of Search & Replace tools on the market for Access. I
use Speed Ferret because I bought it a few years ago and have never had a
need to go with anything else. It will pay for itself the first time you
use it (especially in a case like this where you want to change a field name
everywhere it is used. Don't think it will review ASP code though.

Dale
 
Back
Top