We help IT Professionals succeed at work.

Need help with creating a update query

Medium Priority
281 Views
Last Modified: 2012-06-27
I have below query vbut it is not working.

I am trying to remove "-" and replace it with nothing.
I just want to remove "-"


UPDATE RBS SET RBS.FDN_REMAINDER = "-"
WHERE (((RBS.FDN_REMAINDER)="  "));
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
try this:

UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"-","")
WHERE (((RBS.FDN_REMAINDER)="  "))

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Or with Null


UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"-",Null)
WHERE (((RBS.FDN_REMAINDER)="  "))
James MurrellQA Product Specialist
CERTIFIED EXPERT

Commented:
Personally i would use  


UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"-",Null)
WHERE (((RBS.FDN_REMAINDER)="  "))

source for help on this
http://www.techonthenet.com/access/functions/string/replace.php

Author

Commented:
LOL
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.