Search results for query: *

Perfect, thanks RoyVidar.

Hello all, PHV's solution works great, but is there some way to make it more portable? I have a folder in the same file as the database with several excel sheets in it. These will travel with the database, but what directory the database will end up under is unknown to me. Is there some...

Thanks PHV! That mostly did it, there are a few blanks still but I should be able to figure them out. I am assuming Trim works like the trim in VB, as in removes whitespace before and after the string. Does access add whitespace somehow? After double checking I didn't see any extra leading...

Adding "'s to the statement threw an error. Using %'s didn't throw an error, but returned no results.

SELECT [idNumber] FROM items WHERE items.[location] Like '*areaName*'; where "areaName = area with items in it" brings up all items that have that area anywhere in their location field.

traingamer: trying that gave an error. SELECT [idNumber] FROM items WHERE items.[location] Like '*" & [Forms].[products].[itemSearch] & "*'; ItemSearch is a combobox which draws values from a seperate table. This table has all the areas items are kept.

Still doesn't work. Is there any info I've missed that could help?

Thanks for the quick reply, but no luck. Some additional information: the location being looked for is pulled from a form, so currently I have something like this SELECT... WHERE [table].[location] LIKE [forms].[myform].[locationSearch] I've tried a few variations as well, such as...

In the database I am working on, each record is given a location. The problem is the locations are fairly detailed, making exact matches long and returning only one or two results. Is there any way to search the location field for certain keywords? Example: Item 1 location = "Room1 first...