WineSnob
Not Bright but TENACIOUS
- Local time
- Today, 16:12
- Joined
- Aug 9, 2010
- Messages
- 211
I am building a dynamic filter in code and am trying set the date range for a query. The text fields work fine. I am having trouble with the code for date range. I think I am missing "#" sign to pass to the query. Here is what I have. Any idea how where to put the # ?
Thanks.
' Check for Date Range
If Me.txtStartDate > "" Then
varWhere = varWhere & "[NewWOdate] Between " & Me.txtStartDate & " AND " & Me.txtEndDate
End If
Thanks.
' Check for Date Range
If Me.txtStartDate > "" Then
varWhere = varWhere & "[NewWOdate] Between " & Me.txtStartDate & " AND " & Me.txtEndDate
End If