Extra data

[newtoAccess]

When I go to view my report I get a window asking for input "Table_Sum_All.SumOfCheques". In this report I am not references this item.



If I Click OK and leave it blank my report is displayed without any problems

In the Design view Window I do not see any reference to it.
any suggestions how to find it?

Is there a SQL View as in query design?

[jo15765]

If you open a query in design view, you can then click on View ----> SQL View.

[RuralGuy]

Clear the RecordSource of the Report and save it and then go back in and set it again and save.

[newtoAccess]

So how do I clear the record source in reports?
Guess what the next question is?
How do I set them again?

[RuralGuy]

It is on the Data tab of the Property Sheet for the Report. Highlight it and remembering what it is, delete it unless it is an SQL statement. If it is an SQL statement than press the "..." button and create a static query and save it. then clear the property and save the Report. Then go back in and select the query again.

[newtoAccess]

What view should I be in?
I do not see a data Tab or property sheet yet.

[newtoAccess]

I found it.
It was empty blank

[RuralGuy]

From Design View, right click on the Title Bar and select Properties or just press F4.

[newtoAccess]

I found it.
I had have to select the report main in the top left corner.
now looking for the extra code

[RuralGuy]

How are you running a Report without a RecordSource?

[newtoAccess]

I did find it.
do you want all of it deleted.
or just what is causing my problem "Table_Sum_All.SumOfCheques"

[RuralGuy]

Is it an SQL string or is it pointing to a query? Obviously you should only need to remove the reference to "Table_Sum_All.SumOfCheques" that is causing your problem.

[newtoAccess]

It worked.

I deleted all of it. saved it. and select the correct source and it worked
Thanks

[newtoAccess]

Yap workin ggreat thanks

good night bed time 1:05 am here

[RuralGuy]

Great! Be sure and use the Thread tool to mark this thread as Solved.