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: *

  • Users: mtdew
  • Order by date
  1. mtdew

    Trying to convert Excel 2007 formula to Access 2007

    Alt-F11 Insert Module Option Compare Database 1stPmtCat= IIf(Month([ReportDate])=12,IIf(Nz([first_pmt_effective],0)=0,"1st Pay N/A",IIf([AgeDays]<68,(Month([ReportDate])+1)-12 & "/1 and newer",Month([ReportDate]) & "/1 and older")),IIf(Nz([first_pmt_effective],0)=0,"1st Pay...
  2. mtdew

    Trying to convert Excel 2007 formula to Access 2007

    I get invalid outside procedure error messages
  3. mtdew

    Trying to convert Excel 2007 formula to Access 2007

    Thanks for getting me started. The following works if fist_pmt_effective is blank but otherwise I get an error: 1stPmtCat: IIf(Month([ReportDate])=12,IIf(Nz([first_pmt_effective],0)=0,"1st Pay N/A",IIf([AgeDays]<68,(Month([ReportDate])+1)-12 & "/1 and newer",Month([ReportDate]) & "/1 and...
  4. mtdew

    Trying to convert Excel 2007 formula to Access 2007

    This is how it looks in Excel, how do I need to change it for Access? =IF(MONTH(A2)+1=13,IF(OR(ISBLANK(E2),E2=0),"1st Pay N/A",IF($C2<68,(MONTH(A2)+1)-12&"/1 and newer",MONTH(A2)&"/1 and older")),(IF(OR(ISBLANK(E2),E2=0),"1st Pay N/A",IF($C2<68,MONTH(A2)+1&"/1 and newer",MONTH(A2)&"/1 and...
  5. mtdew

    Is Not Null not working

    Nope. I can pull up the datasheet view and right click to remove all blanks and it works. I can create a filter on the query and it works. I copied the criteria logic from the filter query and pasted it into my query and it doesn't work.
  6. mtdew

    Is Not Null not working

    I have an Excel sheet where the date for field O83 is formatted General. In Access I want the query to only pull up the records where that field has data. I have tried: Is Not Null >01/01/2000 <>"" "*" "/" Like "*/*" Nothing changes it. Unable to change format in Excel because the file is...
  7. mtdew

    Change date format in query

    The field is in the format yyyy-mm-dd 00:00:00 but when I run the query and append the records to another database the format needs to be mm/dd/yy.
  8. mtdew

    Change date format in query

    Is it possible to change a date format from: yyyy-mm-dd 00:00:00 to mm/dd/yy in a query? And also to have the today's date in the field if the field is empty? The data is linked to an Excel file so I'm not able to make changes from within Access. So would that prevent the query from changing...
  9. mtdew

    logic help for months

    Works! Thanks!
  10. mtdew

    logic help for months

    Currently I have: IIF (ISNULL([first_pmt_effective]),"1st Pay N/A",IIF([Age Days]<68,Month(now())+1&"/1 and newer",Month(now())&"/1 and older")) and it works except when it is December, then I get a "13/1 and newer" result. How else can I phrase this to just use the correct months? In Excel...
  11. mtdew

    File name as field

    I need to have several table linked together and know the source of the data. Is there a way to have one of the fields contain the file name from which some of the data is pulled?
  12. mtdew

    Excel sync Sharepoint

    Someone told me if I create a worksheet in Excel 2007 and use the Publish feature to Create Document Workspace the Sharepoint that is created can not be shared by mulitple users although the Excel file is. Is that correct? It just seem to me the whole foundation of Sharepoint is multiple users...
  13. mtdew

    Excel 2007 Unique value from list of names

    I don't get the sheet back after it has been modified by the team members so the macro wouldn't be run by me. I'm currently using the info found at http://www.cpearson.com/excel/ListFunctions.aspx http://www.cpearson.com/excel/NoBlanks.aspx although removing blanks is very slow. And then...
  14. mtdew

    Excel 2007 Unique value from list of names

    SkipVought Pivot Tables cannot be refreshed when the sheet is shared. I love Pivot Tables. I tried. Deniall Thanks for this. I'll give it a try. In the meantime I found something that appears to work. Removing the blanks is very slow so the solution is not ideal...
  15. mtdew

    Excel 2007 Unique value from list of names

    Yes. What I am trying to do is exactly the results you get from a pivot table. However, the sheet has to be shared and updated in real time so a pivot table is not available. Neither is the Remove Duplicate because of the sheet being shared.
  16. mtdew

    Excel 2007 Unique value from list of names

    I don't need to know the number of times the name is on the list. I need to create a list of names. Names Correction Steps Req Needed Corrected Assist. ---------------------------------------------------------- Kim 0...
  17. mtdew

    Excel 2007 Unique value from list of names

    I have Excel 2007. I can't use the Remove Duplicates or Filter functions because I send the sheet out to team members and the file is shared. The formula needs to update in real time as the team members make changes to the file.
  18. mtdew

    Excel 2007 Unique value from list of names

    I create a list of error messages and send it out to a group to make corrections. They enter their name into column A using the drop down box and they enter what they did to correct the error in column B. However, we are expanding and now in addition to the name in the drop down list we have to...
  19. mtdew

    Excel 2007 Unique value from list of names

    I discovered how to pull unique values from a list of names by using: {=IFERROR(INDEX('Daily Fails'!A:A,MATCH(0,COUNTIF($B$1:B2,'Daily Fails'!A:A),0)),"")} but it runs much too slow. Is there another way to pull only unique values from a list of indeterminate length? I'm working with names...
  20. mtdew

    IF(AND in relation to Pivot table filters

    I've created a very complex pivot table which I want to convert to formulas. I have everything completed except for the filters. If there is an option chosen in the filters there's not a problem, but if the user does not choose an option and wants to view all the data for that filter and maybe...

Part and Inventory Search

Back
Top