report not updating- query appear fine?

[Guest]

A report I recently created (that produces monthy totals) is not updating,
although the query in which it is based on IS updating fine. Anyone know of
any general problems that may be causing this? - Any ideas much appriciated!
Kim

 

[Steve Schapel]

Kim,

Can you give some more details, to explain what you mean by "updating"
in this context?

If the data being shown on the report is different from the data being
returned by the query, then the only explanations I can think of are:
1. The report's data is being restricted via its Filter property.
2. The report's data is being restricted via code on its Open event.
3. The report's data is being restricted via the Where Condition
argument of the OpenReport method you are using to open the report.
4. The query that you think is the Record Source of the report, in fact
isn't.

 

[Guest]

- By 'updating' I mean I have a query that holds daily figures in 3 columns
(lets say a, b and c for example.) The report created from this query
produces monthly totals for each column. In the query all the figures that
are there are correct. However in the report, for the previous month, no
figure appears for one of the columns. It is not that the value for this
column is 0. as in the query figures for this month appear.
- Taking your advice I have checked for filters and ther are no filters on.
I am also definately sure that this query IS the record source of this report.
I'm not entirely sure what you mean by the data being restriced by the code

 

[Steve Schapel]

Kim,

Are the controls on the report bound directly to the fields in the
query? Or are there calculations being done on the report itself? How
does the report "know" which figures are supposed to be for "previous
month"? Can you post back with the SQL view of the query?

If you look at the On Open event property of the report, it is possible
that there is an event procedure there which manipulates the Record
Source of the report at run time. It doesn't sound likely, but was just
a thought.

Presumably the report is being opened/previewed/printed via an event
somewhere? The Click event of a command button or something? Normally
by using an OpenReport macro or OpenReport method in VBA code? If so,
there may be a "where condition" argument in the macro or code that
applies an additional criteria to the data. Again, just a thought.