Search results

  1. F

    Solved Query not running, no idea why :(

    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...
  2. F

    Solved Left Join on Union Query not working

    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...
  3. F

    Union query asking to Enter Parameter Values

    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...
Top Bottom