Syntax Error(missing Operator)

[danyellglfer]

I am trying to create a report that would calculate different employee rates
over a large period of time. Rates change so I created two tables. All
Payroll Table has all the employees and the hours as well as what union they
are in and what week ending. The 2nd table is the union table that has the
rates for 3 periods.

To create the report I've first created a QUERY (using the wizard) to pick
out a certian period 05/31/06-9/16/06. The Query is fine... I then try and
create the report and then the report won't preview because of a syntax
error. I go back into the Query and there are two little circles next to the
Query (indicating a UNION) - no clue what that is. But it doesn't appear
until AFTER I try and run a report.

I can run a report if I only use one table but not two.

AND I've been using the wizard because I figure that way I won't screw up. LOL

 

[John Spencer]

UNION is a reserved word and in a query it means to combine two separate
queries into one query. I suspect that the use of UNION as a table name is
the source of your problem. If at all possible I would suggest that you
change the name of the table to tblUnion or UnionTable or UnionPayroll. Of
course, that means that you need to change all the references to the table
also.



--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[danyellglfer]

YOU ARE THE BEST!!!! It now works.

UNION is a reserved word and in a query it means to combine two separate
queries into one query. I suspect that the use of UNION as a table name is
the source of your problem. If at all possible I would suggest that you
change the name of the table to tblUnion or UnionTable or UnionPayroll. Of
course, that means that you need to change all the references to the table
also.



--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..