Characters found after end of SQL statement. Report Print Preview

[OlBill]

Good morning. I am a self-educated idiot and am having a problem with a report.

I have Microsoft 365 Apps for enterprise
Access 2008 Click to run

When I open the report in print preview, it gives me:

Characters found after end of SQL statement.

If I click "Ok" it opens.

I rebuilt the query from scratch and it still does it. I have another report from another query that works fine. I have compared the two and can't see any difference.

Here is the SQL for the offending query:

SELECT Personnel.[Last Name], Personnel.[First Name], Personnel.Craft, Personnel.[Cell #], Personnel.[Team Email], Personnel.[CPC Email], Personnel.Group, Personnel.Active
FROM Personnel
WHERE (((Personnel.Active)=True));



I have also tried yes.

I did delete one column from this query because I didn't need it anymore.

Help would be appreciated.

[pbaldy]

Does the query run without error on its own? I don't see anything wrong with the SQL offhand. If the query opens but the report errors, look for something in the Filter and Order By properties of the report.

[OlBill]

Does the query run without error on its own? I don't see anything wrong with the SQL offhand. If the query opens but the report errors, look for something in the Filter and Order By properties of the report.

Yes, the query runs fine on it's own. The report opens fine in report and layout view. It's just print preview.

I removed the group and sort from the report and still get the message.

[Gicu]

Just curious if one of the fields in your query might contain a semi-colon (maybe multiple emails)? You could use Replace to replace it with a comma if that is the case.

Cheers,

[OlBill]

Just curious if one of the fields in your query might contain a semi-colon (maybe multiple emails)? You could use Replace to replace it with a comma if that is the case.

Cheers,

Double checked, not a one.

[OlBill]

It seems like it started after I deleted the field from the query, but I'm not 100% sure.

[OlBill]

Could it be a colon in the table the query is pulling from?

I looked, not one there either. There are two email addresses, but not in the same field.

[OlBill]

What I really don't understand is why I only get the error on print preview

[Minty]

Put some square brackets around the Personnel.Group,

Personnel.[Group],

I think it's a reserved word and could be confusing the report object (which uses grouping)?

[OlBill]

Put some square brackets around the Personnel.Group,

Personnel.[Group],

I think it's a reserved word and could be confusing the report object (which uses grouping)?

Done, no change. Yes, the report groups on "Group".

So does my other query and report that doesn't have the error.

[Gicu]

Try to recreate the query from scratch with a new name and use that in the report.

[OlBill]

Done. Same error message.

[pbaldy]

Can you attach the db here?

[OlBill]

Can you attach the db here?

No, sorry.

[OlBill]

So I made another report and pulled it from the same query. It didn't have the error.