query: put value in column if rrecord exists

[JonBaugh]

I have a multi table query that I am looking to retrieve a single record from

However one of these tables has multiple records for each previous record so when I run my query, I am recieving results like this

value1 value2 value3 value4
A A A 1
A A A 2
A A A 3
A A A 4
B B B 1
B B B 2
B B B 4

I have a finite number of values that value4 can equal so I would like to have my results come up like this.

value1 value2 value3 value4(1) value4(2) value4(3) value4(4)
A A A True TRUE TRUE TRUE
B B B True FALSE TRUE TRUE

 

[JonBaugh]

sorry for the formatting.... thanks for the help!