[...trimmed text...]

The ACCESS query works, it just give me too much info. Merging the customer and anything in the history table gives me every visit the customer made. I have decided the way to go is to merge into EXCE... Login to read more.