Search results

I have cascade delete in place but I get an error 'Syntax error in From clause'. I copied and pasted directly using Notepad. Thanks

I will give that a go

OK - I have a table Employees and a table Availability. They are joined by EmployeeID - one to many. For each Employee record, one field defines them as Current, Past or Potential. In the Availability table a date field defines from when they were first available. I want to delete Employee...

just the occasional dolphin

I have some Delete Query code taken from the Access query GUI which brings up 'Specify the table containing the records you want to delete'. (I have set up complete referential integrity in all joins). Unfortunately I do not yet understand SQL very well, but after reading your forums I believe...

Hi All. I like Access and use the GUI, but don't use SQL. I live in Wales