Charity.....
For your understanding the reason that I'm having to ask so many questions is that it is not standard practice to put what we would call a key field in a memo field. The memo field makes this more of a problem. We can talk about redesign later.
....the order number field is either 5 or 6 characters, some have a letter and 5 digits but the dupes are all just 5 characters, always numeric, always in the same place.
Is it ALLWAYS the first thing you come to in the memo field? If not, where exactly is it?
Also... send me the complete list of fields.
Name, type of field, field length.
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw