Search results
-
B
Delete query on a union
Steve mate, I do appreciate your help, but when I replace the ShareId that you have used the thing just hangs for hours. No go mate, but thanks. I am still no closer. -
B
Delete query on a union
arnelgp, I am trying to delete all records from the shares table that DO NOT appear in the Union Query. -
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
Bob!!! You are a deadset legend mate! Any idea though why it doesn't prompt the Date range form and instead throws up that little Access request for the start and end dates? How can I make it call up the date range form? Sorry to push the new friendship. Brett -
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])...