Search results for query: *

I have a linked table from SQL 2005 and the date format is YYYY-MM-DD HH:MM:SS. I need to populate an Oracle table with the date, but the format is different, it's YYYYMMDD. I can't find the correct way to convert this in Access.

I have a linked table from SQL 2005 and the date format is YYYY-MM-DD HH:MM:SS. I need to populate an Oracle table with the date, but the format is different, it's YYYYMMDD. I can't find the correct way to convert this in Access.

Thank you Thank you Thank you Thank you Thank you!

Yes and no. Yes because I want that value, but what I need is to use the field names. I've attached the file. TriageTime - RoomTimehttp://www.box.net/shared/rheqeo3bve

I need help with datediff in Access. I'm trying to find the difference in time (minutes) between 2 fields and I can't seem to do it. Both fields are formatted as datetime and look like 2/2/2009 8:14:36 AM. How do I get the difference in time (there are over 17,000 records in the table) for...

Thanks guys, that helped, but I still need to convert the date to the format 200902 from 2/1/2009. I'm working on DateValue...

Ok, I've looked through this forum and can't find what I really need so I'm asking for help. Below is my query...what I want to do is change the date format, currently it's in mm/dd/yyyy but I need it in yyyymm. BUT I also want to remove the prompt and make this an automatic query that will...

I'm using Access 2003 and my queries have never failed me before, I've run the same ones for the past year now without any problems. Now today all of a sudden I can't even view the queries in Design Mode. I get an "Invalid Argument" error. I can't even refresh my linked tables (linked through...