I have a query statement that joins two data sets together giving a list from one dataset and from the other dataset.
'Contacts' contains job_number, contact_surname & contact_forename
'joblist' contains job_number, job_name & status.
In my report want to show all these fields but I can only select a field from one dataset.Code:ReportQuery = "SELECT c.job_number,c.contact_surname,c.contact_forename,j.job_name,j.status,FROM contacts AS c" & _ " INNER JOIN joblist AS j ON c.job_number=j.job_number"
How do I get round it?
At present I and using an alias(AS) to reassign the field to one that has not being used.