Search results for query: *

Sorry, here is the image

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...

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!

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?

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...

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

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...

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?

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

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.

Worked like a charm, thank you!

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

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...

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

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...

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

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

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...

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...

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