I am having trouble with a delete statement that I can't get to work. I am new to SQL and have very limited knowledge so please be kind.
The SQL query will work on a backup table but I can't get it to work on the main table. It seems to work because it doesn't come back with error messages but it says that -0- records have been affected. The two tables are identical as far as I can see (looking at the columns and definitions).
Here is the code:
delete from dbo.Sales
where [Data Date]='12:11:54.0000000' and
I've taken the .0000000 off the time and tried that but that also didn't work.
Any thoughts or help would be greatly appreciated.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…