I've got a parameter query based on one table. The field names in the query don't match the field names in the table.
Hospital isn't a field in Main. What's going on? The query apparently works when run in a DoCmd.OpenQuery statement.VB Code:
DELETE [Main].Hospital AS Expr1, [Main].Hospital AS Expr2, [Main].[Hospital] AS Expr3 FROM Main WHERE ((([Main].[Hospital])<>[Which Hospital?]));




Reply With Quote