I have two columns I want to combine into one query. The date and store numbers would match, but the value in Amount and Other Amount could be located in one or both. When I try to display, I either get only one record that has both amount and other, or changing the join properties either way (2 or 3), I get one or the other. It does not display both at the same time even though values may not appear in one or the other fields. HELP.