Recent content by -Chris-

Afraid it's exactly as stated. To flag up a duplicate of any part of the field, with a duplicate from any part of the same field from another record

Hi all, how do you do it, when for example, in a field, you don't want any duplicates, but in the same field you may have 2 values. So for example, in the email field, in one record you have test2 at emailaddress then in another record (still in the email field), you have test1 at...

No risks are needed in my line of work.

Okay, thanks Brian.

Aaaaargh, just realised, I was inputting the query text into a very similarly worded field! Oooops! With me inputting into the correct field in the query design it all works great. Easily done, and the first mistake in 14 years isn't bad! Thanks to all who gave friendly, constructive...

Yep. The Data Type of [Still going] is text.

Have been using MS Access since about 2001 and have successfully used many 1,000's of queries over those 14 years, just using the method described above, have never needed to use anything to do with sql or vba. Just setting up the query filters, by simply going into the design view for that...

Have also tried : Like "*Manor*" and still no joy.

Hi Mark, not doing any sql or vba, it's just in the design view of a query in MS Access 2007, putting in the criteria field: Like "Manor", but it doesn't return any results for that word, even though there's loads of events for that word in that field.

You seem very confused dear chap, the post explains it in detail!

Hi all, hoping some of you can shed some light on this. In Access 2007, I put into the table, in a certain field, a certain word field, so I put into design view for that query, in that field, Like "Field" and even though the word field is in that table in that field, it doesn't show it in that...