Hello,
I am trying to write an append query to append records that have the highest number in one field(Field1) by using the Max() function with criteria in another field(Field2) being 178 or 179. But for some reason The max function is not working for me. it is still appending multiple records having the 178 criteria for example with different values in Field1. Is there another way to pull the highest number?