vnicosia
Last Activity: Jul 14 '14, 09:00 PM
Joined: Jul 2 '14
Location:
-
Got it to work. It was a field in the sort of the subreport. Thank you all! -
No. It runs fine as a query. It is only when I assign the query to the report I get the message. If I remove the subReport it will run. I have even deleted all of the "TERM" Fields and even tried changing the field names in the tables to separate them from the 2 queries. But I still got the message.Leave a comment:
-
There is also a sub report query:
...Code:SELECT [Contracted Services].TERM , Switch([term]="Summer","a",[term]="Fall","b",[term]="Jan","c",[term]="Spring","d",[term]="Annual","e") AS CustomSort , [Contracted Services].MEASURE , [Contracted Services].Units , [Contracted Services].RateLast edited by NeoPa; Jul 3 '14, 11:40 PM. Reason: Added mandatory [CODE] tags and reformatted to be remotely legible.Leave a comment:
-
...Code:SELECT [Contract Data].[Cont ID] , [Contract Data].[Full Name] , [Faculty Data].[LAST NAME] , [Contract Data].CD , [Faculty Data].[FIRST NAME] , [Contracted Services].[Course Abv] , [Contracted Services].[Course #] , [Contracted Services].Section , [Contracted Services].Rate , [Contracted Services].Units , [ContractedLast edited by NeoPa; Jul 3 '14, 11:28 PM. Reason: Added mandatory [CODE] tags and reformatted to be remotely legible.Leave a comment:
-
Specific field could refer to more than one table listed
ACCESS 2010: I have a report in ACCESS 2010 that when I try to run it says: "The specific field"[Contract Data].TERM" could refer to more than one table listed in the FROM clause of your SQL statement." It ran perfectly until I tried to add a new query that totaled the number of units taught and added a summing query to the report query. They all use the same tables. Not sure what to do.
No activity results to display
Leave a comment: