Page 2 - Recordsets

Originally Posted by slwight

This is going to be easy most likely, but I've been searching and trying different things with no luck.

I have my tblEquip and tblAssets (Equip has all the items I am looking for and Assets are the items that I have found). I can do a SELECT query to see all of the ones I found. I even have it set up to remove the found items from a copy of tblEquip.

However, I can not figure out a way to check to see what items in tblAssets are NOT on tblEquip. In the event that I find an item that isnt listed in tblEquip, I'd like to figure out what those items are. I've been messing around with the SELECT query with the WHERE tblAssets.AssetID <> tblEquip.Tag, but no luck.

Any suggestions? Basically want a way to look up all the items I found in tblAssets that aren't on tblEquip. Thanks!

Originally Posted by don94403

You'll need to write a subquery. It might look something like this, although there are several alternate ways to do it:
Check out: http://msdn.microsoft.com/en-us/lib...2(SQL.100).aspx

This is a fairly common requirement, but it's not intuitive and stumps a lot of people until they are shown how it can be done.

Originally Posted by slwight

That helped a lot. Thanks! Didnt know about subqueries at all. This little project for work is coming to an end. However, just a slight annoyance.

My main form, frmDataEntry, has buttons to open 3 other forms (frmAddNewLoc, frmAddNewPort, frmQryAndRpt). I have a macro opening frmQryAndRpt, but I use VBA coding to open the other two. However, the buttons will ONLY open these 2 forms if I only open them first. Otherwise, I get an error saying: "Access cant find the form '<form name>' referred to in a macro expression or visual basic code."

I keep messing around with this, just wondering if I'm missing something.