I have created a query that works perfectly in Access but it has 3 outer joins to combine the data. When I try to link Excel to this data, it pulls the data from a table but not the data from the outer queries. I need this join to show all data rather than just a portion. I have researched it and it seems that Excel does not like outer joins, found HERE.
Maybe I am not advanced enough but I can't seem to work around in any manner.
Not everyone who will use this data will have the ability to use Access so it must be in Excel. I need the file to be constantly updated or I will be running an update query all the time. Can you either provide me with a workaround or tell me how I can create an action query to run every so many minutes (or upon opening this excel file) without me manually doing this?
Thank you for your help, in advance!
Data that shows is from the YEARDateLinked Table. The columns pull for the query data but does not have the information:
SELECT YEARDATELinked.Date, YEARDATELinked.YearOF, YEARDATELinked.MonthOF, YEARDATELinked.DateOF, YEARDATELinked.WeekNumOF, YEARDATELinked.WeekDayOF, YEARDATELinked.YearAuto, qryUnionDaysbyWeek.Auto, qryUnionDaysbyWeek.FormProjectDays, qryUnionDaysbyWeek.ProjectedDate, qryUnionDaysbyWeek.CountforDay, QRYFormDataLinkedALL.FormName, QRYFormDataLinkedALL.FormProject
FROM (qryUnionDaysbyWeek RIGHT JOIN YEARDATELinked ON qryUnionDaysbyWeek.ProjectedDate = YEARDATELinked.Date) LEFT JOIN QRYFormDataLinkedALL ON qryUnionDaysbyWeek.Auto = QRYFormDataLinkedALL.Auto;