I have the fields WorkDone and Date in a table (Workers) in my access database. An example of the data in the date field is 27/09/2011 15:40:36. I am trying to get the table to only show data for a particular day. So I did TextBox6.Text = Calendar3.SelectedDate
and equated the Date field to TextBox6 using controls (i.e in microsoft visual studio). Therefore, when viewing in a browser, TextBox6 shows the data (27/09/2011) of the selected date on the calendar, but the Workers table doesn't show as the data in TextBox6
is not equal to the data in the date field (27/09/2011 15:40:36).
How can I make it that i can click on a date on the calendar and the table shows me that data (WorkDone) for that day? Or rather, is there an approximate sign in access or sql so as to enable selection of data in the table close to the data that appears
in the textbox?
icenvon
Member
36 Points
35 Posts
Viewing Data By Date
Sep 27, 2011 03:22 PM|LINK
I have the fields WorkDone and Date in a table (Workers) in my access database. An example of the data in the date field is 27/09/2011 15:40:36. I am trying to get the table to only show data for a particular day. So I did TextBox6.Text = Calendar3.SelectedDate and equated the Date field to TextBox6 using controls (i.e in microsoft visual studio). Therefore, when viewing in a browser, TextBox6 shows the data (27/09/2011) of the selected date on the calendar, but the Workers table doesn't show as the data in TextBox6 is not equal to the data in the date field (27/09/2011 15:40:36).
How can I make it that i can click on a date on the calendar and the table shows me that data (WorkDone) for that day? Or rather, is there an approximate sign in access or sql so as to enable selection of data in the table close to the data that appears in the textbox?
Thanks