Cannot find Page... where is it looking?

[That_Guy]

I got the following error 'pgDetailReport$' is not a valid name. make sure that it does not include invalid characters or punctuation and that it is not too long.

When I look at the query in design view it shows SQL Code such as:

UPDATE [ABCD DATA] INNER JOIN [Policy Extensions] ON [ABCD DATA.GEID = [Policy Extensions].GEID SET [Policy Extensions].[Location Data] = [ABCD DATA].[location Data]
WHERE ((([ABCD DATA].[Location Data]) Is Null) AND (([Policy Extensions].Status) Not In ("Pending Approval","Terminated")));

Where the heck is it looking for pgDetailReport$ How do I find out?

I know... novice question, but I really cannot figure it out.

[RuralGuy]

Try *importing* everything into a fresh new db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

[That_Guy]

Thanks, figure it out. It was looking into a table which was then looking at a XLS file with a tab in it.

[RuralGuy]

Great! Thanks for sharing your success and solution. I marked this thread as Solved for you.