sportsguy Finance wiz, Access hack Local time Today, 05:31 Joined Dec 28, 2004 Messages 363 Sep 28, 2006 #1 Text field "CM#000001" How do i write a where criteria to exclude all records that start with "CM#" like "CM#*" does not work like 'CM#' & "*" does not work thanks sportsguy
Text field "CM#000001" How do i write a where criteria to exclude all records that start with "CM#" like "CM#*" does not work like 'CM#' & "*" does not work thanks sportsguy
KeithG AWF VIP Local time Today, 02:31 Joined Mar 23, 2006 Messages 2,592 Sep 28, 2006 #2 left([FieldName],3)<>"CM#"
CraigDolphin GrumpyOldMan in Training Local time Today, 02:31 Joined Dec 21, 2005 Messages 1,582 Sep 28, 2006 #3 or... Not Like "CM[#]" & "*"
sportsguy Finance wiz, Access hack Local time Today, 05:31 Joined Dec 28, 2004 Messages 363 Sep 28, 2006 #4 ah, bracket, that is what I was missing, thanks its a reserved character.. . . sportsguy
