Search results

Thanks - that works.

I thought that there might be a way to solve this problem doing one nested query using the WHERE NOT EXISTS or WHERE NOT IN statements, but I continue to get "missing operator" errors. However, I did follow what you did in the 3 queries in the attached database and that definitely does get me...

Okay, the EXCEPT came from a class but apparently it's not used in Access. What would be the best way then to write a query to find a store that supplied at least one of each product in a table? (i.e. an example of division).

(I posted this as a reply, but should've started a new thread) I have been trying to use the WHERE NOT EXISTS statement in a query, and I keep getting the error message that I'm missing an operator... I've read the article on subqueries, but am still not sure where I'm going wrong. Here's my...

related EXISTS question :confused: I have been trying to use the WHERE NOT EXISTS statement in a query, and I keep getting the error message that I'm missing an operator... I've read the above mentioned article, but am still not sure where I'm going wrong. Here's my code: SELECT S.name FROM...

I have a strange problem where I have finally created a secure database using the security wizard. I'm at the point where I am ready to send it to someone else for use, but I can't seem to move it from my computer to another and get it to open. When I look in the Workgroup Administrator tab, I...

distribute .mdw with shortcut? I am also trying to figure out how best to distribute a secure database with different user groups to a handful of people. I have read some of these posts, but am unfamiliar with how to use the shortcut path that I've seen people mention a couple of times. If...

Thanks for looking at the database. You are correct that each monitoring site is broken into several segments. Each segment may have several different species, which is why I was trying to capture this on a subform of the Riparian Segment form. (In addition, each species may appear on several...

I am having a very frustrating problem similar to one brought up by Alma L. I also have 2 tables linked by a 1:many relationship and have a form with a subform. The error message I constantly get when trying to add a new record to the subform through the form view is: "The LinkMasterFields...

This may seem like a silly question, but it's driving me crazy. I'm trying to use a combox box to choose tree names from a table that has speciesID, tree name, and abbreviation. I have tried setting the bound column in both the form and underlying table to display tree name, but whenever I...