wheddingsjr
Registered User.
- Local time
- Today, 18:45
- Joined
- Jan 20, 2017
- Messages
- 11
Hi all
I created a query in access that retrieving data that has the same data in one field but I also want to eliminate data where the data is the same in another field. I have added two attachments and I will explain them both.
Excel Example: This is the data in the table that I am using. As you can see I wanted all data where there are more than 1 MEMNO which I need. What I doint need are those lines where the COMBO1 fields are also the same. I want to keep those that have the same MEMNO but different COMBO1 numbers.
Access Example: In order to get this data from access. I used the WHERE statement in the attached script (minus the yellow highlited portion). I attempted to copy the original where statement using AND and replacing MEMNO with COMBO1 and replaced the HAVING portion of the WHERE statement with NOT HAVING and it did work. Any suggestions would be greatly apprecioated.
I hope all this makes sense..
I created a query in access that retrieving data that has the same data in one field but I also want to eliminate data where the data is the same in another field. I have added two attachments and I will explain them both.
Excel Example: This is the data in the table that I am using. As you can see I wanted all data where there are more than 1 MEMNO which I need. What I doint need are those lines where the COMBO1 fields are also the same. I want to keep those that have the same MEMNO but different COMBO1 numbers.
Access Example: In order to get this data from access. I used the WHERE statement in the attached script (minus the yellow highlited portion). I attempted to copy the original where statement using AND and replacing MEMNO with COMBO1 and replaced the HAVING portion of the WHERE statement with NOT HAVING and it did work. Any suggestions would be greatly apprecioated.
I hope all this makes sense..