Unexpected Values on Reports

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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13401-unexpected-values-on-reports.html
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.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13401
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!

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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

Dont geddit!

"Simon Harris" wrote in message
news:%23PZy4odqGHA.4760@TK2MSFTNGP03.phx.gbl...
> Hi All,
>
> I have a report which includes two date fields. These are coming out with
> unexpected values.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13401
>
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13401
> 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!
>

On Mon, 17 Jul 2006 21:25:46 +0100, "Simon Harris"
wrote:

>And I've just noticed that them two dates are not in the data any where!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13401
>
>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]