09-27-2017 11:39 AM - edited 09-27-2017 11:42 AM
Great, thank you FredrikE. Worked very well. I created another query(see below) to use only for joining. There was another column ID I needed. I used the MAX function for that column so there would be no repeat IDs from the first column, and because I only need the highest number for that variable.
Need further help from the community? Please ask a new question.