Can you show some sample data?

Hi Richard,

The first screen shot is BankT which shows the raw data imported from the bank, the second (SupplierT) contains the relevant entities I'm trying to match with.  As you can see, I've looked at adding a BankIdentifier field to help with match, however given that the bank data is likely to vary this is unlikely to help.
I'm using Payee as the main match, however need to use the other fields to further refine selection and hence which table to transfer data.

Thanks

I wouldn't put this stuff in three separate tables. Your data already has categories assigned to each payee that should be good enough to tell what category it goes into. There's no need to separate these in the three tables. Remember if it's the same kind of data, the same type of data you don't need to make separate tables out of it. Just like you wouldn't necessarily have to have separate tables for employees, supervisors, managers, customers. They're all people. Just like you wouldn't put deposits and withdrawals in two separate tables for bank transactions. You would just indicate which one was a deposit and which one was the withdrawal. You have that data already in your import table. Just use it.

Thanks Richard,
Funnily enough I had it all in a single table originally, but for some reason which now escapes me i decided to separate them.  If i can't remember it can't have been a very good reason, hence I'll go back to combining them again.
However, i still need to identify the supplier and some other data within import table to enable me to assign those costs to a certain property, or to the company as overheads, and establish which supplier it is.
As a side note, I'm really enjoying the various courses, seminars, techHelp etc you provide on your website, so thank you.  I was new to Access six months ago but have learnt a huge amount since then.  It's all become rather addictive, not sure if that's a good thing or not haha.