<div>
the update statement works perfectly. &nbsp;thanks GreymanMSC.<br />
<br />
appreciate the quick response....<br />

</div>


the update statement works perfectly.  thanks GreymanMSC.

appreciate the quick response....


<div>
<div class="content wysiwyg-content">
I need to be able to run a query that deletes all spaces contained within a field. &nbsp;The table is tblSymbol and has a field symCode. &nbsp;<br />
<br />
Field symCode contains a mixtureof alpha characters and spaces. &nbsp;I need to delete all spaces from within the field. &nbsp;lets say I have someting like<br />
<br />
AA B<br />
CD R<br />
F GG<br />
G H D <br />
FFD (space) (space) etc<br />
<br />
I need to end up with<br />
<br />
AAB<br />
CDR<br />
FGG<br />
GHD<br />
FFD (with no following spaces) &nbsp;in fact no following spaces for any of the symbols in the field.<br />
<br />
need a quick solution here, thanks<br />
<br />
Any suggestions<br />
thanks<br />

</div>
</div>


I need to be able to run a query that deletes all spaces contained within a field.  The table is tblSymbol and has a field symCode.  

Field symCode contains a mixtureof alpha characters and spaces.  I need to delete all spaces from within the field.  lets say I have someting like

AA B
CD R
F GG
G H D 
FFD (space) (space) etc

I need to end up with

AAB
CDR
FGG
GHD
FFD (with no following spaces)  in fact no following spaces for any of the symbols in the field.

need a quick solution here, thanks

Any suggestions
thanks


Delete spaces from field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.