D
DS
I have a Query that works, however I want to replace Query 1 with what
Query 1 actually is in this SQL statement. How would I do this?
This Query 1 in SQL
SELECT MenuDetails.TerminalID, MenuDetails.StartDay, MenuDetails.MenuID,
Days.DayID, Days.DayName
FROM Days LEFT JOIN MenuDetails ON Days.DayID = MenuDetails.StartDay
GROUP BY MenuDetails.TerminalID, MenuDetails.StartDay,
MenuDetails.MenuID, Days.DayID, Days.DayName
HAVING (((MenuDetails.TerminalID)=[Forms]![MenuCreatorPaste2]![TxtID])
AND ((MenuDetails.MenuID)=[Forms]![MenuCreatorPaste2]![TxtMenu]))
ORDER BY Days.DayID;
And this is the working SQL statement.
With Me.ListDay
..RowSource = "SELECT Days.DayID, Days.DayName " & _
"FROM Days LEFT JOIN Query1 ON Days.DayID = Query1.StartDay " & _
"WHERE (((Query1.StartDay) Is Null));"
..ColumnCount = 2
..ColumnWidths = "0 in;2 in"
..Requery
End With
Any help appreciated!
Thanks
DS
Query 1 actually is in this SQL statement. How would I do this?
This Query 1 in SQL
SELECT MenuDetails.TerminalID, MenuDetails.StartDay, MenuDetails.MenuID,
Days.DayID, Days.DayName
FROM Days LEFT JOIN MenuDetails ON Days.DayID = MenuDetails.StartDay
GROUP BY MenuDetails.TerminalID, MenuDetails.StartDay,
MenuDetails.MenuID, Days.DayID, Days.DayName
HAVING (((MenuDetails.TerminalID)=[Forms]![MenuCreatorPaste2]![TxtID])
AND ((MenuDetails.MenuID)=[Forms]![MenuCreatorPaste2]![TxtMenu]))
ORDER BY Days.DayID;
And this is the working SQL statement.
With Me.ListDay
..RowSource = "SELECT Days.DayID, Days.DayName " & _
"FROM Days LEFT JOIN Query1 ON Days.DayID = Query1.StartDay " & _
"WHERE (((Query1.StartDay) Is Null));"
..ColumnCount = 2
..ColumnWidths = "0 in;2 in"
..Requery
End With
Any help appreciated!
Thanks
DS