Search results

Anyone any ideas about alternative solutions?

Don't know what to exactly look there. Might there be some other solution, that for example I create new field in query where date is converted to string?

Used your formula, but didn't work. Error is Syntax error in date in query expression '[Date_Added] = #02.04.2015# And [Shift] = '. Debug.Print Me.Shift result 2 Debug.Print Me.Date1 result 4.02.2015

I tried, but still Syntax error in number in query expression '[Date_Added] = 02.04.2015 And [Shift] = '.

249_1_Chours = 249_1 is machine name and Chours means Check hours. It's a query. Main data is kept in table 249_1_data. Screenshots for both of them can be found website: lean.planet.ee/risto

Names are changed and still Syntax error in number in query expression '[Date_Added] = 02.04.2015 And [Shift] = '. Both textbox fields are now un-formatted. Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= " & Format(Me.Date1, "MM/DD/YYYY") & " And [Shift]...

In immidiate window ?DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= #02/04/2015# And [Shift] = 1") gives the correct result, which is 12

Yes, it's a textbox. I entered date using slashes but it automatically converted it to dots. When I try "[Date_Added]= #" & format(Me.Text27, "MM/DD/YYYY") & "# And [Shift] = " & Me.Text29 & "") then I get: Syntax error in date in query expression '[Date_Added] = #02.04.2015# And [Shift] = '...

I tried your version says: Syntax error in date in query expression '[Date_Added] = #4.02.2015# And [Shift] = '. How can I change textbox to us format?

[Date_Added] is date field. With both of your solutions I get Compile error: Syntax error.

Hello I have a small problem with dlookup multiple criteria. Vba code looks like this: Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= " & Me.Text27 & " And [Shift] = '" & Me.Text29 & "'") This gives following error: Syntax error in number in query...