Search results

I wear the Rotary watch i was given as a 21st birthday present, not too snazzy!

Hello all, I have a table called 'Tasks', where a date is entered along with a short description of the task. I then created a form with an ActiveX 'Calender' on. I also created a subform, this is a datasheet view of all records in the 'Tasks' table. When i click on a new date on the...

The 'DateAdd' function might also be worth exploring... http://www.techonthenet.com/access/functions/date/dateadd.php

Of course not, i appreciate all feedback. Usually, yes, i'd not store calculated values in a table. However with this example, i actually have a temporary table which is created every night using a store procedure. Other SP's then manipulate this data, and the update script is part of the...

Yes, yes and YES! Happy days, thanks alot for your help! Finally got there eh? The final working SQL Update query... UPDATE REPConversion SET Conversion =CASEWHEN (GoneLive > 0)THENCAST(CAST(GoneLive asdecimal)/CAST(targetasdecimal)* 100 asdecimal(3,0)) ELSE 0 END And on your comment...

Now we're getting there! Thanks for your help thus far! My only SLIGHT issue, is rounding (don't scream). A conversion percentage on record should be 5.88, however the new SQL update script has set it to 6. Is there any modification we can make to the script that would accomodate for this?

Thanks very much for your reply. When i apply your select statement into an Update Query, i get the following error: SQL, UPDATE REPConversion SET Conversion =CASEWHEN (GoneLive > 0)THENCAST(CAST(GoneLive asdecimal)/CAST(targetasdecimal)* 100 asdecimal(3,0)) ELSE 0 END Error, Msg 8134...

That's ok, i appreciate you responding anyway. Just hope someone else can help me...

Fyi, i'm using SQL Server Management Studio 2008

Hello, So if i were to apply the Iif statement into an SQL update query, would the below be a good starting point? UPDATE REPConversion SET Conversion = Iif([Target]+[GoneLive]=0, "N/a", Format([GoneLive]/[Target], "Percent"))

Hello. I just ran an update query to set the conversion, however it sets the conversion to '0' for all records. This is the query i used: UPDATE REPConversion SET Conversion = CASE WHEN (GoneLive > 0 AND Target > 0) THEN [GoneLive]/[Target]*100 ELSE 0 END

Hello. After a few hours of tearing my hair out, i'm afraid i have to ask for some of your valuable time in helping me... I have a table with 3 columns; Site, Live, Target. The Live and Target fields are both integers. I have a stored procedure which creates a temporary table and totals the...

I guess i'll be seeing you in August at the start of the trek then? It's quite alarming that you think a mountain that is 5895m - over 19,000ft high, the highest mountain on the continent and the highest freestanding mountain in the world would be completed with relative ease. Of course there...

Create a target, motivate yourself and i'm sure you'll accomplish your goals! You should definitely do it, i'm considering a Marathon but the word itself quite frankly scares me.

I have paid £2,000 for the privilage of raising money for a great charity. No. It will be the experience of a lifetime! I would thank you for your kind support and encouragement, but seeing as you didn't offer any... i won't.

Hello all. As the thread title suggests, i am climbing Kilimanjaro in August 2012 for the Nightingale House Hospice charity. Considered the highest free standing mountain in the world, and the highest mountain in Africa, Kilimanjaro stands at 5895m. Suffice to say, this is a big challenge...

So... The Update query would be something along the lines of... Update MyTbl Set MyField = TRIM(RIGHT(MyField,1)) Or am i way off? :/

I see, is there a way of removing these lines by SQL? Apologies for my ignorance, this is a totally new issue to me.

Apologies... here's the screenshot.

Afternoon all! I hold cross reference data in a table, in a singular 'Text' field. An issue has arisen when performing data exports, it seems that some data has a 'blank line' underneath the actual data. Apologies for the vagueness in my explanation, i'm not quite sure how to put it across...