+ Reply to Thread
Results 1 to 1 of 1

Multiple Criteria, 3 and one can have null value

  1. #1
    Registered User
    Join Date
    10-15-2007
    Location
    Charlotte, NC
    MS-Off Ver
    2003
    Posts
    50

    Multiple Criteria, 3 and one can have null value

    Good afternoon everyone,
    I'm trying to create a summary sheet in excel based on a view I have in an SQL server. I can link the data to the "data" tab and do sumproduct formulas based on the 2 criterias but not 3 if the third can be "null".

    I'm attaching a zip file of the excel spreadsheet, a PDF of what MS ACCESS gives me and the VB code I have to populate the text boxes in ACCESS.....but they would rather have it in Excel (not everyone has ACCESS)

    the data tab are the 0's, 1's, Hospital names and unit names and date
    the summary tab is where I want them to choose the criteria and click a button called "Refresh" to show their data.

    Then they would have to enter their missing links.'

    Any help would be appreciated!

    Larry
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1