Hey everyone,
I am very new to Access, and have little to no working knowledge of SQL or programming in general. My background is finance/accounting, but I've been given a database at work to take over. We've been using this database to store all of the information about equipment we're purchasing. All of this is stored in 1 table (this is how it was before I got it). I have been asked to maintain this table (update as new equipment is added, prices change, etc) and to create reports based off of this data.
I've searched google extensively for an answer to my question, but haven't been able to find anything. I'm not even sure how to phrase it to find the result, which is definitely part of the problem.
One of the reports that I was asked to create is to find the same equipment that occurs in multiple departments. So I'm looking for records with the same "Model #" that have different values in the "Department" field. Doesn't matter if it shows up in 2 different departments, or 20 different departments, we'd want to see all of those records. Conversely, if there are 5 records with the same "Model #" but they all have the same "Department" as well, we wouldn't want to see those.
I think my issue is with the query syntax. I believe I'll be able to format the data in the report once I have the query pulling the correct information.
I apologize if this was not a great description...I'm slowly figuring my way through Access.
Any help you all could provide would be greatly appreciated!