Access Query Question (can't figure out the sql)
Posted on 2009-02-11
Hi everyone, I have a query that I just can't figure out. I have a table that contains the following fields:
GuestID - OfferID - OfferDescription - OfferStartDate - OfferExpireDate - OfferStatus - Field7 - Field8
Field7 and Field8 are booleans (True/False)
There may be multiple records where the first 6 fields are exactly the same, but Field7 and Field8 may differ.
Let's say, for example, that there are 4 records where the first 6 fields are identical, Field7 is false for each of the 4 records, and Field8 is True in two of the four records. I would like to "merge" the records into a single record where Field7 is True if any of the 4 records have True as a value for Field7 and False if none of the 4 records are True for Field7. The same would apply for Field8.
In this instance, I would return a single record where Field7 is FALSE and Field8 is TRUE.
I hope this makes sense. I know there has to be a way to do it, but I just can't figure it out.
I'm using Access 2003 if that makes any difference (although I don't think it does).
Thanks in advance for any help you can offer.