Hi All
I am using Access 2003 and VS 2005 Professional
I retrieve data from an access DB into a datatable then need to select rows
that match a short time value
I can retrieve by time from Access OK
e.g sql = "Select [Details], [mytime], [endtime], [mydate], [member] from
[appointments] where [instructornumber] = " & instructornumber & " and
[mydate] = #" & Format(mydate, "MMM d, yyyy") & "# and [mytime] =
#" & Format(dr("Time"), "t") & "# order by mydate"
dtweek = getdata(sql)
but I can't get the datatable.select to return rows with the same matching
criteria
e.g
drrows = dtweek.Select("mydate = #" & Format(mydate, "MMM d, yyyy") & "#
AND mytime = #" & Format(dr("Time"), "t") & "#")
In the sql line 'mydate' is an access 2003 DateTime field with a format of
Medium Time
In the select line dr("Time") is a datacolumn from a datatable of type
System.DateTime
The following works OK... drrows = dtweek.Select("mydate = #" &
Format(mydate, "MMM d, yyyy") & "#")
It is the time field that is the problem
Any ideas please
Regards
Steve