Capital letter problem?

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi,

Table "A"
----------------------------------------
Item Qty
----------------------------------------
1001a 12
1001b 34
1001A 27
1001a 65
1001c 5
1001B 42
1001A 21
----------------------------------------

Table "B"
----------------------------------------
ID
----------------------------------------
1001A
1001B
----------------------------------------

When I link up two table in a query field "Item" <----> "ID", the condition
in field "ID" is 1001A
but the result show four records, include "1001A" & "1001a",
I want to know how to only show "1001A" records in a query?
Hope someone can help!!


Thank you very much!!
Gary
 
Access is NOT case-sensitive, so you need to use a where clause to further
filter the results

WHERE strComp([A].[Item],.[Item],1) = 0


If you are doing this in the query grid
Field: CaseCheck: strComp([A].[Item],.[Item],1)
Criteria: 0
 
Back
Top