Search results
-
B
Delete query on a union
Can anyone please help me. I have paid for people to fix this but no one can do it. I simply want to delete the rows in a table that do not have matching rows in a union. This works and returns the 2640 rows I want deleted: SELECT * from Shares Left JOIN ( SELECT Indices.Code... -
B
Union query with a where between statement
Hi everyone, I have been reading the helpful posts here and now have one of my own. Could anyone tell me (nicely as I am new, just as you once were) what I am doing wrong in the following code; SELECT Maint_PM.[Machine ID] From Maint_PM Where (Between (([Forms]![Date Range]![StartDate])...