I can't seem to make a querytable in Excel 2007 bring in a query that is using DCount to exclude holidays in my NetWorkingDays formula in Access. When i try to link the query, it tells me it can't find my "tblHolidays" table.
Is there a way around this so I can use a query table in my report?
Cross-post: http://www.mrexcel.com/forum/showthread.php?t=582299
Is there a way around this so I can use a query table in my report?
Code:
WorkDayDiff: -(([Req#dlv#dt]-[Act Date])-(DateDiff("ww",[Act Date],[Req#dlv#dt])*2))-DCount("[Holidays]","tblHolidays","[Holidays] > #" & [Act Date] & "# and [Holidays] < #" & [Req#dlv#dt] & "#")
Cross-post: http://www.mrexcel.com/forum/showthread.php?t=582299
Last edited by a moderator: