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!

Register Log in
  • Congratulations Rhinorhino 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: NJko4
  • Order by date
  1. NJko4

    Excel - Dynamic Lookup to populate a cell

    Have departmental Excel worksheet that have 4 columns; Name, Phone No., Supplies that I have, and Supplies that I need, and Comments. Note, there are 75 rows that correspond to each of the 75 employees in the department. Is it possible to have the "Comments" field populated with the name and...
  2. NJko4

    Excel Nested If with Sumproduct - Compare Dates

    Data is not in all of the rows 5 - 56000, Some of the rows between 5 and 56000 are blank.
  3. NJko4

    Excel Nested If with Sumproduct - Compare Dates

    Did take a look at using MS Query for the issue. However, is it possible to use a combination of sumproduct and nested if statements to determine if a particular MS Excel cell with dates is before or after another date?
  4. NJko4

    Excel Nested If with Sumproduct - Compare Dates

    Have a six-column Excel worksheet that have approximately 26,000 records in columns A through C and 28,000 records in columns D through F. Columns A through C is the admit and discharge dates for the employees at Hospital 1 and columns D through F are the admit and discharge dates for employees...
  5. NJko4

    Create "Conditional" Calculated Field in Excel Pivot

    Have a MS Excel 2002 pivot table with three row fields; Chg Amt, Paid Amt, and Nbr of Visits and column fields that consist of the 12 months for 2007. Is it possible to create a calculated field that will divide the value in a particular cell within the pivot table by the respective membership...
  6. NJko4

    Display results of QBF in listbox that is on form

    Creating a QBF in MS Access 2002 and interested in displaying the results in a listbox that is at the bottom of the form. Upon displaying the results, I would like to give the end user the option of transferring to Excel, text or email. Is this doable? How should I accomplish?
  7. NJko4

    Excel 2002 Pivot Table - Add Calculated Field

    Have pivot table where the page field is Vendor Name; the column field is service_month and the data elements are Sum of Paid, and Sum of Units. There are 12 service months - from Jan through Dec. What I am trying to accomplish is to insert a column after each service month that displays the...
  8. NJko4

    Run - time Error 2501 - MS Access Form cmd button

    I can view the reports while at work but cannot view on the laptop from home. I have MS Access 2002 at work and MS Access 2003 on the laptop. References on the computer at work are; Visual Basic For Applicatons Microsoft Access 10.0 Object Libary OLE Automation Microsoft DAO 3.6 Object Library...
  9. NJko4

    Run - time Error 2501 - MS Access Form cmd button

    Not able to resolve a run-time error using MS Access 2003. Upon clicking on a command button on a MS Access form, I receive a run-time error. Upon accessing the code, the line beginning with DoCmd.OpenReport... is highlighted. Any idea on the source/resolution of the problem? Private Sub...
  10. NJko4

    Populate Excel column with occurrence number

    Spoke too soon! It appears that the formula is working. Thanks.
  11. NJko4

    Populate Excel column with occurrence number

    Well, it didn't work - There are 1s populating each row in the column.
  12. NJko4

    Populate Excel column with occurrence number

    Wow! That was quick response! Thank you, I will try the suggestion.
  13. NJko4

    Populate Excel column with occurrence number

    Have the following in an Excel 2003 spreadsheet: MbrID---VisitDate---VisitNumber 2684----1/4/07 2684----1/6/07 2684----1/10/07 4873----2/1/07 4873----2/5/07 4873----2/15/07 Is there any method available where the column titled "VisitNumber" can be populated with the number of the visit? For...

Part and Inventory Search

Back
Top