[AccessD] A2K: Exact match in query

Steven W. Erbach serbach at new.rr.com
Tue Sep 28 16:24:43 CDT 2004


Charlotte,

>> Access is not case sensitive by default and the query engine isn't at
all, although you can force binary comparisons using InStr with the 0
option to force a binary compare. <<

Ah! That sounds like the ticket.

>> Are the two productIDs actually for different products?  If so, you
might want to find one of the values and replace all those with a new
ProductID that won't confuse the issue as well. <<

The customer has to do some inspection of his data before this program is put into production. Yes, the two product IDs represent identical products, just entered sloppily. However, each occurence of the product has different attributes. Only the customer can confirm which is the right one.

Thanks, Charlotte.

Steve Erbach





More information about the AccessD mailing list