Search results

Yep, that worked. Thanks! Now what if you have multiple instances. I noticed that when I tried to do an OR...that the table output was incorrect. So basically I had to do embedded IF's since I was searching for monitors by brand. I basically copied the entire line...here's part of the code...

I think LIKE "*phrase*" might be what you're looking for? For example if you want to search for "red" then you say. like "*red*" Not sure if that's it though.

I have a table which has 3 columns PCNAME PRODUCT, and SERIAL. For the PRODUCT I've narrowed them down to cpu's and monitors, along with their serial number. So basically a good portion of the work is done. However on the output the report of course lists most pc names twice since each one...

Very strange problem and I will try to explain it as best as I can. We have a custom program that has now been converted to SQL and runs on the employees Access 2003. At one point in the program is a call to send email to the persons manager and this is where the program locks up. Here's some...

I have an .mdb which holds one table. This table is referenced by two other Access applications which link to it. In one of the programs there's a form that all of the needed values are pulled into from that linked table (user name, administrator flag, etc...). A query filters into this form...