Windows 7 
Access 2010 (version 14.0)
Making A Query Criteria Urgent Help
hello
I'mnew to this forum, I've come to ask the access experts for some urgent required help.I'll start from the beginning, i have 2 linked tables in access 2010, one of them is called "Labelled Orders" and the other is "Label Stock" they each have several fields, they both have a description field which are both similar except the "Label Stock" "Description" field data all starts with "LBL" followed by a summarized version of the "description" field in the "Labelled Orders" table.what i'm trying to do in a query is for it to only display the data that's in both the tables the "label stock" "description" starts with "lbl" that why i don't know how to get a criteria to only pick up the similarities from the 2 tables. I tried the "[Label Stock].[Description]" in the "Labelled Orders" "Description" Criteria field but i get no data. I'll add screen shots to kinda show what i mean.
Reply With Quote
Originally Posted by jarrydred
