Access Query Question (can't figure out the sql)

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.

-Scott