var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Eliminating Spaces
I have the following sample data
Product ID Description
12345 3" Round White Ball
24832 3" Round WhiteBall
What I need to do is eliminate the spaces between the description so I can eliminate Product ID's that have similar descriptions....is this possible????
Have you tried using the function"REPLACE"?
For example, REPLACE(description, ' ', '')
How do I do that
Do I put that in the criteria of the field description? Sorry for my ignorance...
I assume you have the Description field on a form.
You can add the REPLACE function on the afterupdate event of the Description field. For example,
Private Sub Description_AfterUpdate
Desription = REPLACE(Description, ' ', '')
Hope this helps.
Actually it is in a Query
The following query should give you a list of products with the same description.
SELECT productid, Replace(Table1.description,' ','') FROM Table1;
Hope this helps
It does not
I have checked the results of the query and they are not duplicates...not exactly sure what it is producing????