Gossamer Forum
Home : General : Databases and SQL :

Re: [Mad_Mick] Delete Carriage return query

Quote Reply
Re: [Mad_Mick] Delete Carriage return query In reply to
I would try the following:

- Create a new field in your table to receive the changed data - a
nice safety idea
- Open New Query in design view
- drag in the table
- drag the field containing "" to the bottom pane, I'll call it
[CodeField] for now
- drag the [NewField] to the bottom pane
- click the "Query Type" button and select Update Query
- In the [Codefield] Criteria line, put
Like ""
- In the [Newfield] UpDateTo line, put
"" or " "

Click the big fat exclamation mark which will run the update.

hope that helps ...
Subject Author Views Date
Thread Delete Carriage return query Mad_Mick 90773 Jan 18, 2004, 7:10 PM
Thread Re: [Mad_Mick] Delete Carriage return query
Andy 90416 Jan 19, 2004, 2:48 AM
Post Re: [Andy] Delete Carriage return query
Mad_Mick 90189 Jan 19, 2004, 2:45 PM
Thread Re: [Mad_Mick] Delete Carriage return query
llccoo 90264 Jan 25, 2004, 9:23 AM
Thread Re: [llccoo] Delete Carriage return query
Mad_Mick 90291 Jan 26, 2004, 1:52 PM
Post Re: [Mad_Mick] Delete Carriage return query
Watts 90187 Jan 26, 2004, 3:36 PM
Thread Re: [Mad_Mick] Delete Carriage return query
llccoo 90181 Jan 26, 2004, 3:43 PM
Thread Re: [llccoo] Delete Carriage return query
Mad_Mick 90171 Jan 26, 2004, 4:34 PM
Post Re: [Mad_Mick] Delete Carriage return query
llccoo 90139 Jan 27, 2004, 4:17 AM
Thread Re: [Mad_Mick] Delete Carriage return query
Watts 90169 Jan 28, 2004, 9:39 AM
Post Re: [Watts] Delete Carriage return query
llccoo 90163 Jan 28, 2004, 8:45 PM
Thread Re: [Mad_Mick] Delete Carriage return query
KarlS 86653 Jul 8, 2005, 11:49 AM
Thread Re: [KarlS] Delete Carriage return query
BI 86455 Jul 26, 2005, 3:17 AM
Post Re: [BI] Delete Carriage return query
theryall 68150 Nov 13, 2007, 1:16 AM
Thread Re: [Mad_Mick] Delete Carriage return query
justin.kearney 65912 Feb 29, 2008, 7:01 AM
Thread Re: [justin.kearney] Delete Carriage return query
LaLa 63234 Jun 24, 2008, 4:47 PM
Post Re: [LaLa] Delete Carriage return query
justin.kearney 63141 Jun 25, 2008, 5:37 AM