[AccessD] A2K: Exact match in query

Doris,

>> Try using Ucase(DailyFID3.[Facility Part #]) = Ucase(Product.[Facility Part
Number]) -- it will force all the alpha characters to upper case. <<

Won't this still add two records? Because both occurences of the [Facility Part Number] will be upper case now and there are still two different product numbers?

Steve Erbach