Search results

THANK YOU!!!!!!! everyone. John, the statement you sent does work. Again thanks everyone who helped. Rey --It does help to ask--

I tried having different tables, but I still had problems. I also tried the wild cards with this new table, and still did not get the results I was looking for. Here is an exaple of my dbs if you like to take a look at it.

I tried =[enter equipment name], and I tried [enter equipment name] with out the equal sign, which if I am not mistaken is the same as the one with the = sign. It does give me some of the resulsts I want, but the records that contain other quipment items do not show. for instance, I enter query...

My problem is the following: I have a table thak contains equipment reservation information of peple who need to use these euqipment, in the equipment field I want to have different kinds of equipment such as Overheads, Laptops, LCDs, and so on, and I also want to have a query where I can...

I think I got it this time. I created a table with the user information and another table for the equipment information, I made a relation between the equipment fields and I think I got what I needed (at least for the query). I will need to create a form to enter this information. Thanks...

If I had a database of all the equipment I think this would be easy, unfortunatelly I don't. My problem is that I have many different users for the same piece of equipment, sometimes I get a person requesting a piece of equipment for the entire year for maybe once a week, but this equipment...

I created two tables: 1.- user information such as name, use date, time, place, etc. 2.- equipment such as computer, projector, laptop, etc. Table number 2 is a yes/no table, so I only have to mark what kind of equipment this person is going to use. My question is, how do I create a...