Using Access 2007
So I am trying to perform a search using a query;
Like "*" & [What Item] & "*"
It searches the table "ITEM" I also have the same search under "COMPANY" and "PART NUMBER" but when I run it nothing appears. Even when the search criteria is blank I get no entries. there are 1005 separate entries that it should be searching, but it appears to be searching none. I did notice that when I messed with some settings I could get it to return entries when I typed a number in the ITEM search, but there was no numbers in any of the descriptions? I think it is searching the main index key, but why? :banghead:The table I have it under should be the DESCRIPTION of each ITEM. I hope that made sense.
So I am trying to perform a search using a query;
Like "*" & [What Item] & "*"
It searches the table "ITEM" I also have the same search under "COMPANY" and "PART NUMBER" but when I run it nothing appears. Even when the search criteria is blank I get no entries. there are 1005 separate entries that it should be searching, but it appears to be searching none. I did notice that when I messed with some settings I could get it to return entries when I typed a number in the ITEM search, but there was no numbers in any of the descriptions? I think it is searching the main index key, but why? :banghead:The table I have it under should be the DESCRIPTION of each ITEM. I hope that made sense.
Last edited: