Search results

Thanks jdraw. I was so fixated on "changing" what was being appended I totally missed the fact I can get the transaction type ID number directly! Thanks for your help.

Thanks for the response. The example database is essentially a generic version - just much simpler, i.e. less columns and only one that can be referenced via a separate table. I have updated names as per you comments. It may be my naivety not understanding exactly what you mean - I was not...

Thanks jdraw. Unfortunately I can't share the data as it is confidential but I have created a simple example of what I am trying to do. I have searched, but I can't find what I am looking for, probably because I am missing something! Attached is a very simple database. The [Original Data]...

Upfront - I am a newbie to Access (so be gentle!). I am converting an flat excel file containing sale and purchase transactions to an Access relational database - 12 out of the 37 columns have repeating values. I have created individual tables for these values and the base table of...