Recent content by tegand

Hi Everyone Thankyou for your help so far, I am still super confused as to how I can get this working. I am working on cleansing my DB of all sensitive data, as it is all pretty sensitive so I can attach it, but for now I thought i'd attached the SQL view of the query I am trying to figure...

Hi Everyone I have a query in which I have created that extracts all payments that have not been paid (no invoice number). In one of my source tables I have an invoice number field (as my query draws from several tables it has become read only) which needs to be populated when the query is run...