Underlying query not updating

[Chance1234]

In my Database i have a query which i have recently changed the source of two of the columns.

Ie

AllUserData.datetime1 AS Start

Is now

AllUserData.SQLVariant1 AS Start

However when using the report designer on my reports, I am still getting the old value appear.



Chance,

F, G + 1MSTG

 

[xlbo]

Hi Chance - Have you clicked the "Update Fields" button in the Data view ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Chance1234]

Just putting it down to a gremlin, updating fine now just on that day, it didn't .

Chance,

F, G + 1MSTG