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.