THank you so much for your effort so far! I would use code but I may need some help understanding where to put it. I have dabbled lightly with SQL but not ASP so that would be completely new to me.
Let me just give you a quick background on this data-I am an accountant and I am trying to do a clearing account reconciliation in Access because at the moment we have no reconciliation software for it. I am really trying to do more with Access than it is meant to do
I ultimately need to have a query that shows me all the records that do not match, so maybe we should focus our effort there only. (Perhaps it would be easier than the match query anyway). Using your data as an example, I would love to write a query that would return to me records 2, 7, & 9.
I look forward to your response!