J jbphoenix Registered User. Local time Today, 11:49 Joined Jan 25, 2007 Messages 98 Jun 18, 2007 #1 I need to create a query and find records where the customer id starts with 4016. I know this is fairly simple but I can't remember how to do this.
I need to create a query and find records where the customer id starts with 4016. I know this is fairly simple but I can't remember how to do this.
boblarson Smeghead Local time Today, 10:49 Joined Jan 12, 2001 Messages 32,040 Jun 18, 2007 #2 In the criteria, type Like 4016* (if a number) Like "4016*" (if text)
J jbphoenix Registered User. Local time Today, 11:49 Joined Jan 25, 2007 Messages 98 Jun 18, 2007 #3 Thanks Bob - I was forgetting the *