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
icenvon
Member
36 Points
35 Posts
Re: Viewing Data By Date
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.
hans_v
All-Star
35986 Points
6550 Posts
Re: Viewing Data By Date
Sep 27, 2011 06:40 PM|LINK
SELECT * FROM workers WHERE datevalue(Workdone) = @Workdone
http://office.microsoft.com/en-US/access-help/datevalue-functie-HA001228814.aspx
http://www.mikesdotnetting.com/Article/92/MS-Access-Date-and-Time-with-ASP.NET
http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access