Originally Posted by
neilsolaris
Many thanks Bob. Whilst I did set table relationships, it's entirely possible I didn't do it correctly, or fully. I'll watch that video you sent me in a bit, and check I've done it properly. The way I got it to work though, was to bring the T_MusiciansDetails table into the query as you suggested, but I then entered the VAT number into the query, and referenced that field using the IIF function, to generate the VAT amount.
Thanks for the advice about the CCur() function. That's interesting to know. Maybe I'll leave it as it is then.
My next task if to create self/billing or remittance advice PDF files for each player/engagement, using the data from this query. I managed to automate this before using excel and VBA, but I'd like to do it using Access now. Can Access reports be used to automate this process, or should I be looking to use VBA? Many thanks.