data type mismatch in criteria expression

[ivonsurf123]

Hello Everyone,

Could you help me to find out what is wrong with my query, please? The problem is on the [Date of Change] which is a Date field

Me.RecordSource = "SELECT tbl_GCDS_Operations_Positions_Fills_Log.* " & _
       "From tbl_GCDS_Operations_Positions_Fills_Log " & _
       "WHERE (((tbl_GCDS_Operations_Positions_Fills_Log.[Date of Change])='" & Me.cboDate.Column(0, Me.cboDate.ListIndex) & "')) " & _
       "ORDER BY tbl_GCDS_Operations_Positions_Fills_Log.[Date of Change];"
    Me.Requery
 
 

Thank you.

[twinnyfo]

Ivon,

Try changing line 3:

"WHERE (((tbl_GCDS_Operations_Positions_Fills_Log.[Date of Change])= #" & Me.cboDate.Column(0, Me.cboDate.ListIndex) & "#)) " & _

You had the WHERE statement looking for a text value. The "#" indicate a date is expected.

Hope this hepps!

[ivonsurf123]

You are awesome! Thank you.

[twinnyfo]

Any time! Glad to be of service!

[NeoPa]

Don't forget to explain to students that dates should never be used in SQL strings just as they come (See Literal DateTimes and Their Delimiters (#)). It will generally work in the USA, but nowhere else in the world.

[twinnyfo]

I meant to reference that article, but forgot. Thanks, NeoPa!