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

    Custom Data View for list

    Is there a way to create a data view to only show projects assigned to the user? Thanks, Kevin
  2. Cordeiro82

    Sharepoint IF statement using dates

    Thanks Carl. Both formulas ended up working in SharePoint. I did later realize that the dates in the list spanned more than two fiscal years so I expanded the formula to fit any date range. =IF(MONTH([start date])>=7,CONCATENATE("FY",(YEAR([start date])+1)),CONCATENATE("FY",YEAR([start date])))
  3. Cordeiro82

    Sharepoint IF statement using dates

    nevermind. I answered my own question. IF(([start date] > "6/30/2010"+0), "FY11", "FY10")
  4. Cordeiro82

    Sharepoint IF statement using dates

    Hello All, I am trying to create a calculated column using an existing column that contains dates. The statement is as follows : IF([start date] > 6/30/2010, "FY11", "FY10") However, sharepoint does not seem to be reading 6/30/2010 as a date and keeps giving me FY11 as the return value even...
  5. Cordeiro82

    Combo box used to find record in form

    Hello, I am using a combo box to lookup records in a form based on Vendor ID. If the user enters a vendor ID that is not in the table the form defaults to the first record in the table. How can I have the form display a pop-up notifying the user that the Vendor ID is not in the system and...
  6. Cordeiro82

    SUMIFS in excel 2003

    Yes Thanks.
  7. Cordeiro82

    SUMIFS in excel 2003

    Hello All, I am running Office 2007 and can use SUMIFS to sum all IF statements. However, my collegues are running on 2003 - How do I create a similar statement in excel. I have tried using nested IF's but it did not work. My SUMIFS statement is here: (SUMIFS('Sheet 1'!A:A,'Sheet 1'!X:X,"5...
  8. Cordeiro82

    Inform members when document is posted?

    Is it possible to inform all members of a document library when a document is posted? Thanks
  9. Cordeiro82

    Incoming email for task list in MOSS 2007

    I do not see the incoming email option in the settings for task lists. Is it possible for users to send documents via email to a project task list in MOSS 2007?
  10. Cordeiro82

    Moving multiple folders into a new folder

    Hello All, I am trying to move multiple folders that exist in a document library (MOSS 2007) into a new folder created within that same document library. How can I do this? Thanks.
  11. Cordeiro82

    MS Excel 2003: Expanding merged cells with text wrapping

    I have an excel document containing merged cells. However, when text entered into a merged cell overflows into a larger space than the merged area the cell does not expand. All merged cells are wrapped. Is there a way to have the merged cells expand when needed? Thanks.
  12. Cordeiro82

    Section Page Numbers in MS Word 2003

    perfect! I did not know about the unlink function. Thank you.
  13. Cordeiro82

    Section Page Numbers in MS Word 2003

    Hello All, I have two sections in a five page word document. The footer of the document contains the page number. The first section has three pages and is numbered 1-3 of 3. The second section is numbered 1-2 of 2. Is there a way I can remove the page numbers from the footer of the second...
  14. Cordeiro82

    Converting an igrafx (.igx) to a visio file (.vsd)

    Hi, I have a very complex swim lane diagram in igrafx and re-creating the whole thing in Visio would be a complete waste of time. Is there a way I can convert the igrafx document to a Visio document? Sotware being used: iGrafx FlowCharter 2006, Visio Professional 2003 Thanks.
  15. Cordeiro82

    Max query function

    I wanted to add some more information There are five fields in the table [ItemNumber], [CreateDate], [PONumber], [OpenQty], [Supplier] In addition to finding the last purchase order created (Max[CreateDate]) for each item is it possible to only return the largest qty if there are more than two...
  16. Cordeiro82

    Max query function

    Hello, I am working with a purchase order table that has a field called [CreateDate]. Each [ItemNumber] might have multiple purchase orders with a different [CreateDate]. How can I run query to only show the records for the last created puchase order for each item? Thanks, cordeiro82
  17. Cordeiro82

    calcuation based on date

    Thanks guys. I would like to piggyback this question with another one. Now that I have 6 slots for future orders my crosstab looks something like this Material | Today | 1 | 2 | 3 | 4 | >4 A B C When I try to link...
  18. Cordeiro82

    calcuation based on date

    Hello All, I have a future orders table that contains a date field [datedue]. The table is refreshed everyday, and the dates begin with the day of the refresh onwards. I would like to create an additional field that is populated with the following text: "Today" for min[datedue] (which would...
  19. Cordeiro82

    counting days in a weekday dependant formula

    Hello, I currently have a Query that calculates the number of days that an order is late using Now()-[tableX].[DateX] The problem with this is that the number returned is the count of calendar days and not business days. Is there a way to count only business days (Mon-Fri)? Thanks, Cordeiro82

Part and Inventory Search

Back
Top