Dlookup error

[Risto85]

Hello

I'm trying to set Dlookup result as Label caption, but unfortunately I get error message:

Run time error '3075':

Syntax error in number in query expression '[Date_Added]=4.02.2015 And [Shift] = '1'.




Dlookup looks like this:
Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= " & Me.Text27 & " And [Shift] = '" & Me.Text29 & "'")

[June7]

Date_Added is a data/time type field? Date parameters need # deliminter.

Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= #" & Me.Text27 & "# And [Shift] = '" & Me.Text29 & "'")

Are you outside the U.S.? Access accepts the dot in place of / in the date?

Is Shift a text type field?

[Risto85]

I'm outside US, in Estonia.
Shift is Numeric field.
Now when I added # I get following error:

Syntax error in date in query expression '[Date_Added] = #4.02.2015# And [Shift] ='1'.

Date_Added is a data/time type field? Date parameters need # deliminter.

Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= #" & Me.Text27 & "# And [Shift] = '" & Me.Text29 & "'")

Are you outside the U.S.? Access accepts the dot in place of / in the date?

Is Shift a text type field?

[June7]

Since Shift is a numeric field, remove the apostrophe delimiters from around Me.Text29. Apostrophe delimiters are for text fields, # for date/time, nothing for numeric.

[Risto85]

Hi,

I still get error with formula Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= #" & Me.Text27 & "# And [Shift] = " & Me.Text29 & " "):

Syntax in date in query expression '[Date_Added]=#4.02.2.015# And [Shift]= 2'.

[June7]

Remove the & " " at the end of the expression. This could be concatenating a space to the Text29 value.

Also, I suspect the periods in the date are not being handled by Access. Try:

Replace(Me.Text27, ".", "/")

[Risto85]

Label34.Caption = DLookup("[Spent_Hours]", "249_1_CHours", "[Date_Added]= " & Me.Text27 & " And [Shift] = " & Me.Text29)

Error is: Syntax error in number in query expression '[Date_Adde] = 4.02.2015 And [Shift='.

It can find date but there is problem getting the shift number correctly.

[June7]

This does not make sense. Going in circles. If you want to provide db for analysis, follow instructions at bottom of my post.