Hi all, first time poster, long time lurker who has found plenty of answers to my questions from this forum so thank you all in advance
I am quite new to Access, Im fairly competent in VBA but an absolute novice using SQL, so bare with me and hopefully this makes sense
Im building a quality database but i am having trouble writing an SQL statement populating my Row Source
I have 4 tables tblCATOnlist, tblCATOfflist, tblCATClinical & tblCATAgedReport where the data is submitted from frmCATOnlist and so on. Each table has different criteria and calculated fields to determine the overall quality score so I am unable to combine all the data into one table
Each table contains the same 5 fields which i want to be displayed in my listbox namely Reference (CATON***** for tblCATOnlist etc), Type, Date_Entered, Reviewed_By, Agent & Score
I was wondering how i could go about combining the reference results into a single reference column and display the additional fields corresponding to the reference number
The results would then need to be clickable to display the original completed form (if that makes a difference) which i'll figure out using VBA
Hope that make sense and please ask any questions
Thanks
I am quite new to Access, Im fairly competent in VBA but an absolute novice using SQL, so bare with me and hopefully this makes sense
Im building a quality database but i am having trouble writing an SQL statement populating my Row Source
I have 4 tables tblCATOnlist, tblCATOfflist, tblCATClinical & tblCATAgedReport where the data is submitted from frmCATOnlist and so on. Each table has different criteria and calculated fields to determine the overall quality score so I am unable to combine all the data into one table
Each table contains the same 5 fields which i want to be displayed in my listbox namely Reference (CATON***** for tblCATOnlist etc), Type, Date_Entered, Reviewed_By, Agent & Score
I was wondering how i could go about combining the reference results into a single reference column and display the additional fields corresponding to the reference number
The results would then need to be clickable to display the original completed form (if that makes a difference) which i'll figure out using VBA
Hope that make sense and please ask any questions
Thanks