Search results

Hi there, I have a table with a field called 'dereg_date' which is formatted as text, an example is as follows: 2006-07-07 00:00:00.000 I want to be able to convert this field to a date. I have tried using a query with Cdate([dereg_date]), however it doesn't convert it and just returns...

Hi there, Not sure if this the right forum.... I work for a retailer. Each retail site has an individual SQL database. I want to extract the same information from each database, therefore I have created a batch file that connects to each database, using the IP address, and then runs the same...

Hi there, I'm trying to query tables I have imported as 'linked tables' from a SQL database. I've built a query, but when I run the query it says 'Invalid Procedure Call' Does anyone know why it's doing this? Many thanks!, Sasha.