Search results

Hi, Can someone please help? I am trying to sum 3 different time fields together in a report that all are the same format but it wont allow me to. The expression i have built is =Sum([ACDTime]+[AgentRingTime]+[OtherTime]) but I get back a error message saying... "This expression is...

It seems the reason that i am also having problems is due to the fact my date format in my table is actually TEXT...

Hi All, Can someone please help? I am struggling to change the format of 2013-07-29 11:33:03.6160000 to show dd/mm/yyyy Thanks in advance, G

Thanks for that. Quick question, i should know this but i seem to have a memory block....how do i change a field in a query to TEXT. Do i start my query by using FORMAT([Time]etc...... G

Hi All, Can you please help? I am having difficulties changing a date/time field like '22/04/2013 09:14' to make it look like '2013-04-22 09:14' using a query. Can someone please suggest a way of changing this? Thanks, G

Hi All, I have attached a calendar control to a form and what i am wanting to do is when someone selects a date and then presses a button, the date writes back to an existing table and a specific date field. Can someone please help in anyway? Is this possible? Thanks, G

Hi All, I am new to the site. Just a quick question, can anyone point me in the right direction to a holiday database template what i can edit to track 50+ staff's holidays for 2012. I have searched the forums for an answer but i cant seem to find anything. Thanks, Gary