T
Tony B
Hi All
I am trying to match postcodes(UK) to a field that is derived from the
first part of the postcode. i.e. Postcode = bb12 1aa and field =
bb1. However if field bb1 is allocated to say user1 and bb12 is
allocated to user 2 then both are returned when I use this in the
query:
WHERE (((Top_75.POSTCODE) Like [User_postcodes]![Postcode] & "*"))
<<<
Is there a way to ensure that only the user with the exact match is
shown.
TIA
Tony
I am trying to match postcodes(UK) to a field that is derived from the
first part of the postcode. i.e. Postcode = bb12 1aa and field =
bb1. However if field bb1 is allocated to say user1 and bb12 is
allocated to user 2 then both are returned when I use this in the
query:
WHERE (((Top_75.POSTCODE) Like [User_postcodes]![Postcode] & "*"))
<<<
Is there a way to ensure that only the user with the exact match is
shown.
TIA
Tony