Hello. I am new to Access and working with a list of data that has the following fields: Ident, BusinessDate, Type. The purpose of my request is to try and find those people (Ident) that the first time they visited my business (BusinessDate) was from a particular promotion (Type.) Basically, if John Doe came in on 1-1-13 without a coupon but he came in on 1-7-13 with a coupon, I would like to have the report state John Doe , 1-7-13.
Does this make sense? Using the query design view I can get either the first time a guest comes to my buisness or the type of promotion a guest uses. I cannot get the two of them together. Any help would be appreciated.
Thank you.
John