D
DS
I have a problem with the following DCount statement.
I keep getting a Syntax error, any help appreciated.
Thanks
DS
Me.TextMenus = DCount("[MenuID]", "MenuDetails", " & _
"TerminalID = " & Forms!Form4!TxtStation & " " & _
"AND MenuID = " & Forms!Form4!TxtMenu & " " & _
"AND StartDay = 4 " & _
"AND StartTime = " & <Time() & " " & _
"AND EndTime = " & >Time() & " " & _
"AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")
I keep getting a Syntax error, any help appreciated.
Thanks
DS
Me.TextMenus = DCount("[MenuID]", "MenuDetails", " & _
"TerminalID = " & Forms!Form4!TxtStation & " " & _
"AND MenuID = " & Forms!Form4!TxtMenu & " " & _
"AND StartDay = 4 " & _
"AND StartTime = " & <Time() & " " & _
"AND EndTime = " & >Time() & " " & _
"AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")