In Access 2000 I have a report based on a query. The report works as desired. When I start the query by itself I get "Invalid operation" and an empty Help screen. I also get "Invalid operation" when I try to start a new form I am basing on the same query. I have executed the query by itself in the past, and I do not believe I have made changes in it without executing the query directly before running the report. What might I be doing wrong?
This conversation is currently closed to new comments.
You might be referencing some member of an object, such as the report, a variable, a form element, or anything with "Me!" in it in the query. Since that object isn't defined outside the report, you'd get errors.
FROM ((((((EventArray LEFT JOIN dbo_PROVIDER ON RefSchool=EXT_ID) LEFT JOIN dbo_PROVSITE ON [dbo_PROVIDER].[PROV_ID]=[dbo_PROVSITE].[PROV_ID]) LEFT JOIN DemographyHigh ON ([EventArray].[Client_Event_Date]=[DemographyHigh].[Client_Event_Date]) AND ([EventArray].[Patient_ID]=[DemographyHigh].[PATIENT_ID])) LEFT JOIN InsuranceHigh ON ([EventArray].[Client_Event_Date]=[InsuranceHigh].[Client_Event_Date]) AND ([EventArray].[Patient_ID]=[InsuranceHigh].[Patient_ID])) LEFT JOIN dbo_EVENTLOG ON ([EventArray].[Patient_ID]=[dbo_EVENTLOG].[PATIENT_ID]) AND ([EventArray].[Client_Event_Date]=[dbo_EVENTLOG].[EVENT_DATE])) LEFT JOIN Authorizations ON [dbo_EVENTLOG].[EVENT_ID]=[Authorizations].[Event_ID]) LEFT JOIN PatientAsPerson ON [EventArray].[Patient_ID]=[PatientAsPerson].[PATIENT_ID];
EventArray is the name of a table. RefSchool and EXT_ID are fields in tables - you would know which tables except that the comment field was not big enough to take them. I have used the IIF construct successfully outside reports. When I copy the SQLtext into a new query the new query works for a while but then starts saying "Invalid operation".
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
report works, query doesn't