Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. starbird2273

    Interactive Image as Web Part

    Sorry, here is the image
  2. starbird2273

    Interactive Image as Web Part

    Hello everyone. I am trying to add an image to a SharePoint 2007 site. I can easily add the image to a Library, use SharePoint Designer 2007 to add hotspots, and the hotspots open links to various places. I can also use the default mouseover to get the text to be a high level description. All...
  3. starbird2273

    Excel Bar/Column Chart y-axis label help

    Actually, I got it to work. I basically started over with a new chart and it took care of it. Very odd it didn't the first time. Unless, of course, I made a change. Thanks for your help!
  4. starbird2273

    Excel Bar/Column Chart y-axis label help

    Yes, that is how it is set up (Although not sure if this makes a difference, I am using Column A (Teachers) and Column L (Total). Each Month is in between. That is exactly how I'd like my chart to look. How did you do it?
  5. starbird2273

    Excel Bar/Column Chart y-axis label help

    Hi, I have a column chart that is tracking the number of boxtops by teacher for my daughters school. Everything on the chart is just as I would like it to be EXCEPT the legend/label on the Y Axis Simple Table layout is: Teacher1 #boxtopsYTD Teacher2 #boxtopsYTD ... Teacher20...
  6. starbird2273

    Custom Dropdown list?

    Actually, I just got it. So simple, I missed it the first 50 times.... Thnsk!
  7. starbird2273

    Custom Dropdown list?

    Hi there. I have a MPP that I want to add a column to that would be a custom drop down. It is something we use for our corporate project schedules, and I am one of the few who uses Project (most use Excel). I want a column that will have the following in a drop down list. Not Started In...
  8. starbird2273

    Fixed length Text Export Question

    Thank you. This is working well. However, I have leading zeros that are not staying with the records (for example, $40 should be 0000004000, but is coming up 40.00) any ideas for that?
  9. starbird2273

    Fixed length Text Export Question

    thank you, but will that include the missing fields? I just want basically this as the output fld1 -don't have fld2- have, need to start at position 11 fld3 - don't have through fld13 - don't have fld14 - have, need to start at position 150
  10. starbird2273

    Fixed length Text Export Question

    Hi, I have a specific format that I need to take data I have in a table and export to. The catch is I only have 3 of the 14 fields, and the rest are not required. Is there a way to do this? I saw some information in thread181-536954. Thanks.
  11. starbird2273

    multiple sum on same field with criteria

    Worked like a charm, thank you!
  12. starbird2273

    multiple sum on same field with criteria

    Running it now. will let you know the results. thanks for your help!
  13. starbird2273

    multiple sum on same field with criteria

    SELECT dbo_V_rpt_Claim.DTL_Recovering_Organization_Name, IIf([Bus_Line_Cd] Is Null,"Commercial", IIf([Bus_Line_Cd]="COM","Commercial", IIf([Bus_Line_Cd]="Commercial","Commercial", IIf([Bus_Line_Cd]="MCR","Medicare", IIf([Bus_Line_Cd]="Medicare","Medicare","Medicaid"))))) AS Product...
  14. starbird2273

    multiple sum on same field with criteria

    Thank you. I am a bit confused. would my complete SQL help?
  15. starbird2273

    multiple sum on same field with criteria

    ok, I have seen several great ideas that get me part way to my need, but nothing that seems to get me what I am looking for. Here are the fields I am using State Vendor Product amt_Identified amt_Closed amt_Recovered amt_Balance Recovery_Reason I want my output to look like this, grouped by...
  16. starbird2273

    Top Ten (10) by ID from one table

    it should be. a quick pivot table proved this. any other thougts? I really appreciate your help
  17. starbird2273

    Top Ten (10) by ID from one table

    Thank you. still coming up with the additional lines. but it ran quick
  18. starbird2273

    Top Ten (10) by ID from one table

    Yes. Here is the full code from the qry. SELECT A.MinOfPRV_FULL_NM, A.MinOfPROV_PRTCP_STS_CD, A.SumOfTOTAL_PAID, A.MinOfPD_POL_NBR, A.MinOfSBSCR_NBR, A.MinOfREL_CD, A.MinOfFST_NM, A.MinOfLST_NM, A.MinOfMPIN, A.MinOfPROV_TIN_PRFX_CD, A.MinOfPROV_TIN, A.MinOfPROV_TIN_SUFX_CD...
  19. starbird2273

    Top Ten (10) by ID from one table

    AH.... Never more than 10 DIFFERENT amounts. Is there a way to just get the top ten? and if there are more than one of an amount, I only get 10 total back? My end result should return no more thant 10 records for each MonOfPROV_TIN. so if one MinOfPROV_TIN had $50 75 times and nothing...
  20. starbird2273

    Top Ten (10) by ID from one table

    Over 100 records. for the same MinOfPROV_TIN. I am looking for only the 10 highest FIN_Recovery_Balance_Amount

Part and Inventory Search

Back
Top