Sorry I need to define between customers in specific areas, so when a query is requested to include only people in the Plymouth area, i.e. only specific postcodes PL1 - PL9 and PL19 - PL21 as the in between postcodes are not plymouth area so the above postcodes need to be tagged as a particular code i.e. EH which is the code for the relevent areas newspaper, rather than the user having to do a between criteria search for each postcode!
So the ideal would be to update the table and have EH entered to all of the matching fields,
Let [PostCode] be the field for you postal codes.
Let [OtherField] be the field where u enter in that "EH" stuff..
then using ADO..
Dim conn as adodb.connection
Dim rec as adodb.recordset
set conn = currentproject.connection
set rec = new adodb.recordset
rec.Open "SELECT [PostCode], [OtherField] FROM [TableName];", conn, adOpenStatic, adLockOptimistic
for i = 0 to rec.RecordCount - 1
if (Left(rec(0), 2))="PL" then
dim number as integer
if((number>=1) AND (number<=9)) OR ((number>=19)AND (number<=21)) then
rec(1).Value = "EH"
rec(1).Value = "MN"