Removing Characters from field

[NetworkGhost]

Is there any way when doing a query to loop through the results of a field and remove characters like a "~" or something?

 

[PHV]

Have a look at the Replace function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[NetworkGhost]

Is there a List first or List Last Function?

 

[ZmrAbdulla]

May be BOF and EOF are you looking for

________________________________________
Zameer Abdulla
Visit Me
Minds are like parachutes. They only function when they are open. -Sir James Dewar (1877-1925)

 

[NetworkGhost]

What exactly is BOF? How would I use it?

 

[earthandfire]

If rs is a recordset variable then:

rs.BOF is the point in the recordset immediately before the first record and rs.EOF is the point immediately after the last record. As such if both rs.BOF and rs.EOF are true the recordset is empty.


Hope this helps.

 

[ZmrAbdulla]

For a detailed description pls search in the VBA help file (while you are in the code window)

________________________________________
Zameer Abdulla
Visit Me
Minds are like parachutes. They only function when they are open. -Sir James Dewar (1877-1925)

 

[jsteph]

If you're talking about looking through the actual field and finding the first or last "~" or whatever, there is an InstrRev function, which is basically Instr() but it starts at the end, this may help.
--Jim