Re: Filtering out dashes for Comparison

[colemanj4]

On Jul 15, 10:23 am, fredg <fgutk...@examp le.invalidwrote :

>SNIP
>
Select .... etc ...
WHERE CustTbl.SN =Replace([forms]![CustFleetInform ation]![Cylinder
 Number],"-","");
>
Only records that contain 123-456 or 123456 in that [SN] field will be
returned.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -
>
- Show quoted text -

Worked great. THank yuo very much!