Search results for query: *

Both of those were great. I did a check, and in both cases, it only summed up one of the child records (child WO's) so that the total hours for record 12346208 showed as 7 instead of 9. How I corrected this: I added "ID" within the Union selects. Why I did this (no clue if this is correct...

Greetings - trying to modify an access table/create a query to compare multiple records against a parent, and sum the values of a field and list only one record - the parent record. The parent record, when one exists for a WO#, is listed in the "Parent" column, and the actual parent record can...

Hi Jon, That's the ticket! Sneaky way to get around it - I never would have thought of it. Much appreciated, take the rest of the day off. Best regards, Doug

Hi John - Thanks for the response - no, that isn't what I am looking for, unfortunately. That's what I meant by stretching the application screen out and showing multiple windows - the "arrange all" feature. I want to be able to have two separate instances of PPT open, side by side, similar to...

I would like to open 2 separate powerpoint presentations side by side, in their own separate application instances. I don't want to have to stretch the application frame out wide and have two separate windows open within the same application instance. You can do this with MSWord & MSExcel, but...

Right... it may be surprising to you, but I already searched excel's help before posting. And as far as what I want to retrieve - everytime "J6R" appears within a string in a cell, I want to return "J6R" in another cell. So the first cell that I am searching may have "asdfalsdf J6R...

I need to write an equation that I can use to search a cell for a string of text, and if it finds it, return it. Example: If cell A1 contains the text string "J6R Dllser" I want the value "J6R" to be displayed in cell B1. Thanks!

Right, but adding a scroll bar to the chart to modify that value displayed in the text box (referring to a cell in a spreadsheet within the same workbook)is very easy. Which, by the way, fully meets the question I posted. Thanks again for the help. My question has been answered, you both...

Andy - excellent tip, thanks. Exactly what I was trying to do. Best, Doug

Hi Skip, Let me make it a one part question - I want to be able to display a CELL VALUE on a chart. I want a direct link to that cell, displayed not as part of the chart, but like a text box, pasted on top of the chart. Any way to do that? I don't think your explanation does that, although I...

Hi Skip, Pretty nifty methodology. However, I am still interested in displaying a cell value on the chart. For instance, I have a calculated value that I want to display along with a few series on a chart. Best, Doug

How can you automatically display a cell value in a text box? I want to have a scroll bar on a chart that modifies a cell value displayed somehow on the chart (text box is my un-educated best guess...). I want the chart to be its own individual worksheet, and I want to allow users to scroll the...