Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Sep 27, 2011 06:40 PM by hans_v
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?
Sep 27, 2011 04:21 PM|LINK
Hello. Don't worry. I think I went about this the wrong way..LOL!! Will try another way.
Sep 27, 2011 06:40 PM|LINK
SELECT * FROM workers WHERE datevalue(Workdone) = @Workdone