DBASE IV Account Number Problem

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

Guest

I'm importing a DBase IV table and am having a problem with the account
numbers for each record. Apparently, DB4 uses the pound symbol "#" in their
account numbers and when I try to run an Access query with a record that has
account number with a "#" in it, the query doesn't work.

Is there a way to globally-replace the pound sign (can't seem to do that
because the # sign is used by Access 2002 for a particular purpose (dates).
Any other suggestions for this issue?

Any help would be greatly appriecatiated. Thanks in advance for your help.

Gary
 
I'm importing a DBase IV table and am having a problem with the account
numbers for each record. Apparently, DB4 uses the pound symbol "#" in their
account numbers and when I try to run an Access query with a record that has
account number with a "#" in it, the query doesn't work.

Is there a way to globally-replace the pound sign (can't seem to do that
because the # sign is used by Access 2002 for a particular purpose (dates).
Any other suggestions for this issue?

Any help would be greatly appriecatiated. Thanks in advance for your help.

Gary
Click to expand...

The # character is OK in a Text field *if* you are finding an exact
value: e.g.

WHERE AccountNumber = "#1243"

would find all records (probably all one of them <g>) with that
account number.

If you're using wildcards using the LIKE operator, you must enclose
the # character in square brackets - it's the wildcard for a numeric
digit. For example to find all accountnumbers consisting of an
octothorpe followed by three numeric digits you could use

LIKE "[#]###"

In an update query, using A2002 and later, you could update
AccountNumber to

Replace([AccountNumber], "#", "")

to simply trim out the octothorpe.

John W. Vinson[MVP]
 
Back
Top