I like to refer to my question:
This is the code for my form to select different sources (tables).
SELECT Funds.Fund_Number AS FundNumber, Funds.Fund_Name AS FundName, Funds.Reg_Fund AS RegFund
WHERE [Funds].[Reg_Fund] = [Investments].[IG_yes]
SELECT Funds_Other.Fund_Number, Funds_Other.Fund_Name, Funds_Other.Reg_Fund
WHERE [Funds_Other].[Reg_Fund] = [Investments].[IG_yes]) AS Q
ORDER BY StripOutCharType([Q]![Fund
ue ," , " "), Val(StripOutCharType([Q]![
I have to create a report based on this form and more information. The report was working with my old query (one source only). With the new constellation of data, -different sources, I get a Type mismatch as a fault in the report.
The query I am using is untached and I am aware of problems of the old query. How can I integrate the new functions?
Thanks for your support.