Thanks for the input guys.

You may be right about the multiple records but before I left here on Friday I ran a test update and entered a bogus but easily...

Thanks again everyone, got it to display exactly how I wanted.

Cheers !!

Sorry for the confusion, but I am trying to poutput a new field titled MyField02 which value relies on the value of the first field.

Thanks again for all your assistance,...

Thanks guys.

The code works but what I am trying to do is change the value of MyField02 which relies on the value of MyField. So if MyField is 7 then...

Thanks guys !!

Thanks Gail, that worked perfect.

Cheers for the advice, at the moment I am just testing the tables but this may well become a monthly task so I may well...

Ah Thanks Jack.

I have to get into that way of thinking rather then the old DestinationField = SourceField way.

Thanks again.

Cheers Steve, I did just that.

It was asking for a connection so I placed the Connection object in there but could not link it to any of the other objects...

Ahh right, that makes perfect sense then.

Thanks so kindly for the link, i'll look into this.

Thanks again,

Mitch....

Lynn thank you so much for your time and help on this.

You've pratically saved my bacon !!

Mitch.......

Thanks for your patience and input Lynn, I really appreciate it.

Using

SELECT Cycle_Cutoff_DT

FROM TIPTest02

WHERE Cycle_Cutoff_DT < dateadd(mm, datediff(mm, 0, getdate()), 0)

GO

brings in the same Dataset as we tested earlier,...

OK, for the first statement the result is 2009-01-31 00:00:00.000,

so by changing the value of the last digit the date changes.

The second statement displayed the result of 2008-12-31 00:00:00, which...

Ack, this is embarrassing because I can't figure it out.

I ran thsi statement on qry analyzer, select dateadd(mm, datediff(mm, -2, getdate()), -1)

GO

and got the date of 2009-02-28. I then...

Thanks for the prompt reply Lynn.

Unfortuantly i'm not getting any results and this may be due to the DataType for the field I am using.

I have the Datatype as SmallDateTime...

Thats great stuff guys.

Works like a charm, I really appreciate your help.

Thanks,

Mitch....