J
JB_96RS
I am trying to relate two fields in different tables. Both fields ar
called lot. In one table the lot number shows as 2-11111 and in th
other it sometimes has an E at the end 2-11111E. I have used:
Like [Table1].[Lot] & "*" with Table2 in the grid. The query return
no records.
Attatched is a sample of what I am trying to do
+----------------------------------------------------------------
| Attachment filename: db1.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=169135
+----------------------------------------------------------------
called lot. In one table the lot number shows as 2-11111 and in th
other it sometimes has an E at the end 2-11111E. I have used:
Like [Table1].[Lot] & "*" with Table2 in the grid. The query return
no records.
Attatched is a sample of what I am trying to do
+----------------------------------------------------------------
| Attachment filename: db1.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=169135
+----------------------------------------------------------------