Been asked to create a query in Access 2002 that looks through a large table of records of personal data for entries in a 'Salutation' field that does not begin "Dear" (eg "Dear Mr Bloggs"). I've tried '<> "Dear*"' but no joy. I'm sure the answer's an easy one but in 8 years of using Access I can't think I've had to create this type of 'not' query before.
Any ideas please on a neat solution? Ta.
Any ideas please on a neat solution? Ta.