Search results

Thank you. Made these changes and it worked.

Hello, I'm hoping someone can help to get my query to run. At work I've inherited a database and now need to add a new year to the query that calculates hourly rates. Below is the query I've updated, the line I added is highlighted red. However I get a 'Syntax error (missing operator) in...

Hi all, thanks for your advice on this one. I went with plog's suggestion of making each select it's own query.

Hello, Hoping some one can educate me on LEFT JOINS a bit. I'm trying to add a LEFT JOIN to a UNION JOIN but when I run the query I receive the following 'Syntax error (Missing Operator) in query expression ‘t0.Project = t3.[Project Code] Left JOIN [Ref_Project Cost Centres] AS t4 on t0.[Task...

Thanks all, I have managed to resolve this now. It turned out that the download from the online database was changing the names of the headings depending on which year the report was run for

Hello I've seen various threads on similar problems as mine but none have been able to resolve the issue. I have 3 tables I want to append using a union query, as I don't want all the columns I'm not using the Select * From but instead entering the column headings I want, below is my SQL...