Unexpected Values on Reports

[Simon Harris]

Hi All,

I have a report which includes two date fields. These are coming out with
unexpected values.

The reports data source is QRY_INVOICES. Looking at the query on its own,
the values look fine.

When I run the report, the values for the two dates are always 07/01/2006
and 01/01/2006 (Thought I would mention the values in case there is anything
significant about them).

I have also noticed that these do not change when moving from record to
record within the report - They always stay static. I thought perhaps I had
done something to make them always retain some value, but if I drag these
columns onto the report as fresh objects, I see the same behaviour.

I should also mention that the database recently went corrupt, and I had to
create a fresh DB and import all the objects.

Very odd, I am at a loss as to what to try next. Any help/suggestions much
appreciated.

Thanks,
Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!

 

[Simon Harris]

And I've just noticed that them two dates are not in the data any where!

Dont geddit!

 

[John Vinson]

And I've just noticed that them two dates are not in the data any where!

Dont geddit!

Sounds to me like they're in unbound Textboxes. What is the Control
Source property of the textbox in which one of these dates appears?

John W. Vinson[MVP]