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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.