Hi all,
No idea why this is happening, but i have 2 queries, qry_EmailResolver_***ORGANISATION NAME*** and qry_EmailResolver_External. Both generate different results using the same format, and I have joined them together with the UNION query qry_EmailResolver_All. Both the first 2 queries run perfectly, without prompting any values and generating the expected results. However, when I run qry_EmailResolver_All, I get a prompt for qry_EmailResolver_All.E-mail for some reason, which is unexpected.
The union query is as such:
Code:
SELECT [tbl_*StudentProfile].[Student ID], [tbl_*StudentProfile].Forename, [tbl_*StudentProfile].Surname
FROM [tbl_*StudentProfile] INNER JOIN tbl_AuditImport ON [tbl_*StudentProfile].[***ORGANISATION NAME*** Email] = tbl_AuditImport.[E-mail]
UNION
SELECT [tbl_*StudentProfile].[Student ID], [tbl_*StudentProfile].Forename, [tbl_*StudentProfile].Surname
FROM [tbl_*StudentProfile] RIGHT JOIN tbl_AuditImport ON [tbl_*StudentProfile].[External Email] = tbl_AuditImport.[E-mail];
Any help much appreciated.
EDIT:: My field name is not actually ***ORGANISATION NAME***, I just replaced the name of my organisation with that in the post.