Recent content by Hacim

Thanks for your response. just got back to work. SQL seems to recognize the = sign as the begining of a statement after the < sign I get an error. thanks for trying

i'm trying to edit a sql statement from an existing custom report that involves technician time charges. the existing statement shows time charge data for "yesterday" I can't figure how to write the statement for the last 30 days. the existing state reads: where datediff(day...

Problem just started with my plotter. I'm using win XP pro I can print anything but pdf's and tiff files

I haven't used a scsi card for some time. I was too quick to assume there were newer models with different numbers. Thanks for your help.

My Vidar Truscan Select P-75 engineering scanner has not been used in a couple of years and my pc's have been replaced with new ones. I am running win XP pro sp2. The scanner was originally purchased with an adaptec 2930 scsi card. The vidar website has a software and firmware download for older...

I changed back to coated paper, calibated the plotter, set the color options to "managed by application" and the colors are much better. thanks

I downloaded what I thought was the latest driver. Can't figure out why colors on the plot are not matching what I'm seeing in the dwg on the monitor (hp 30"lcd 2560x1600 resolution)

I am using wmplayer 10 with win xp Eventually, after watching any number of short videos, when I double click on a file nothing happens unless I reboot the pc. The number of files opened before this occures varies. Also, (this may not be related)when the screen goes into screen saver mode and I...

Since I was only evaluating one cell as anotherhiggins mentioned, I used his formula =IF(J28=0,0,SUM(J17:J28))/1000 and went to the tools-options- view tab and unchecked "zero values" so any cell with a zero value would be blank. (which is what my anal boss requested) Thanks

Now I am getting a #VALUE in the cell when I try this formula =IF(SUM(J28)=0,"",SUM(J17:J28))/1000

Using Excel 2002 sp3 I am trying to create a formula that will keep the cell with the range total, blank until a number has been input into the cell that is been summed. This is what I have tried with no sucess. =IFSUM(B28)=" "," ",SUM(B17:B28) Thanks for any help.

Thanks for the formula, if I insert a text box I can conditionally use a custom color as the background.

Am using cr 8.5 Can't remember how to set the detail section background color for every other row like it appears in this forum's web page. thanks for any help

AlexIT Thanks for your help, I'll give it a try.

Running exchange Server 5.5, service pack 4 We are using a module in a Maintenance Management Software package called MP2 messenger that is designed to automatically send email notifications to anyone that has been set up to submit work requests via a web page on our local network. For example...