Search results

This seems so simple but I just cant figure out how to take inventory values and get the difference. I have an item table with basic info and an inventory table with Just item no, inventory date and qty. On report, I want to calculate the difference of the inventory. Not SUM and I just cant...

Ok, so I "split" the database and it is on a server in another state. Me and my college here in this state can access the db at the same time but when I tested adding someone from the other state and she can not get in unless we are out. After she is in, we can get in but not if we are in first...

I need help on sharing databases. I have a database located on a server that I want several people to be able to be in at a time and can not remember how to arrange that. Currently, some people just can not get in while others can. Can anyone help me please?

How do I look up several fields from a table and then dump them into one field in another. Please Help! I want item description and price to go into another table field "Comp1" :confused: NEVER MIND - I JUST FIGURED IT OUT !!!! THANKS ANYWAY!!!!

Thanks to help from this site, I got me "Like" query to work but now while trying to generate a form on this data, I am getting the following error msg. It pulls up the data correctly, it just always comes up with this error: "You Can't Search The Field For The Specified Value". Also, my photo...

Can anyone help me? I cant figure out how to get a form to run off a query that searchs by partial field (like anything with "gum" in it). I am using this in my query criteria but after the prompt, no records come up. Please help: "*"&[Enter Key Word]&"*"