M morlan Registered User. Local time Today, 06:51 Joined Apr 23, 2003 Messages 143 Jun 6, 2003 #1 I have multiple records and I need to run a query that will filter postcodes beginning with BS and LS. Any ideas what criteria I would use for this
I have multiple records and I need to run a query that will filter postcodes beginning with BS and LS. Any ideas what criteria I would use for this
Mile-O Back once again... Local time Today, 06:51 Joined Dec 10, 2002 Messages 11,305 Jun 6, 2003 #2 Add a calculated field: NewField: Left([PostCode], 2) with the criteria: "BS" Or "LS"
