Recent content by danhauer

Thank you all SOOOO much!! I was able to get the report to the customer this morning - - in the format they wanted!! I did have to use Ken's tip to create a formula with a zero value, use it, then remove the zero and save. Thanks again and again.

Hi Daniela - I tried something like that and still got the error "A number is required here". :-( if month({@DDateClosed}) = 1 then {@DaysOpen} else {@Dummy} Thanks for the response, though. If I can't figure this out, I think I will group by month, which should fix it but the format won't...

I have to find the median number in columns of data, without counting zeroes. The zeroes are the result of a formula. I tried saying if {@days} > 0, then {@days} else null or "" but that didn't work because of course, the formula expects a numeric value. So my report looks like: JAN FEB...

I got it!! {=MIN((IF($F$37:$F$750=$J37,IF($A$37:$A$750=200,0, SUM(IF($F$37:$F$750=$J37,IF($A$37:$A$750=15,1)))))))} It's not pretty, but it works. Thanks for the hundreth time for all of your help. You are the hero of the day - you really saved my neck!! danhauer

Yogi!! Thanks a million! This worked beautifully. And I learned something new about Excel arrays. Ummm, one more thing, if you have time... I just got told that there is another condition that I have to count for. They want to count where there is an occurrance of code 15 only if there is...

Thanks Yogi - this is how I started to do it, but the input is going to be cut and pasted weekly from an html file into Excel with varying lengths of data for each date, so the formulas would have to change each time. That's why we wanted to use VB (and a macro button) to read, calculate and...

(Sorry, the search was down for maintenance, so I didn't get to search thoroughly...) I have several rows (not many, just 300 or so) of two columns of data in Excel. One is an error number, the other is a date. What I need to find is the number of occurrences where two numbers fall under the...

Hi, I am trying to show the $REF field in a view. Is there a way? (I need to see the number that is stored in that field on a whole bunch of documents.) Thanks danhauer

Thanks everyone! I ended up copying and pasting each one and running it from the query window... only because I was spending so much time trying to find an easier way that I could just do it and get it over with. But, I have more to do and will definitely explore the great suggestions. Thanks...

Oh hey, no offense - no way! I take all the help I can get, and sometimes the obvious things are things I overlook! I appreciate your comments! I tried pasting the whole script into SQL and saving it, but it poops out after the first statement ("characters found at end of SQL statement") and...

Hey LJ... thanks for answering so fast! I tried the run sql in macro and the text is too long... here is an example of what I am trying to do: INSERT INTO T_SC_CRITERIA ( SUPPLIER_TYPE, CRITERIA_ID, MEASURE, CATEGORY, MIN_MEASURE, MAX_MEASURE, WEIGHT, POINTS, ENTITY, CHANGE_DATE, RACF_ID...

I have a series of queries and I just want to run them one at a time without retyping. I have an Oracle script that I modified with a bunch of statements that I could copy and paste 30 times, but I'm looking for a way to place a comment so I can just uncomment them one at a time and run them...

I'm using Office XP, and everthing was fine when I made charts. Then for no "apparent" reason, one day when I went to make a new chart (nothing fancy, just the default chart using the chart wizard) and the plot area was so small I couldn't even find a handle to drag it and make it...

If you are using the query wizard, then just insert the column you want to total along with the data you want to group by, and then click the Totals icon (kind of looks like a backwards 3). That will add a Totals row to your field columns. It has a drop-down box where you can choose group by...

Hello - This seems like it should be easy, but I cannot find a way to write a formula to update a cell with the date/time of the last change on the spreadsheet. I can do it with code, but I need to pass this info on to users. Is there a way? I tried convincing them that they could do a...