Recent content by ivan_a

Thank you Pat, that actually helped me solve my problem!

Thank you for the suggestion, I will probably go that route, was just hoping there is a way of avoiding adding too many new queries.

These reports contain the same information, but for different people, so I need to union them so that I get the full list of people in both reports. However, report2 has one additional field, which contains information that corresponds to another field in report 1.

That would still not solve my problem in full. Fundamentally, I have one column in report 1 called [future term date] and two columns in report 2 called [effective date] and [future term date]. What I want is for my Union query to take [future term date] from report 1 and [effective date] from...

Thank you for the replies, to your points: ridders arnelgp- I was not clear, in that one of the reports has one additional column, so that is why I want to get rid of it. bob fitz - sadly no, the rows contain dates which can be the same ridders - I could add a dummy fields, but I would later...

Hello, I am trying to import 2 excel generated reports into ms access tables and once they are imported I want to make a union query out of the two. The problem I have is that two of the fields in report1 are different than report2 so my union will not work. I need to make one of two things 1)...