Search results

  1. O

    Question Using Substring

    Thanks guys
  2. O

    Question Using Substring

    Hello, I have a field with string that I will like to trim the last two letters. The problem for me is that the total characters length will almost always be different. Please help me with removing the last 2 digits of whatever is entered. Example: User entered ABC123445A THT676746...
  3. O

    DSum With Multiple Criteria and Date Value

    I am happy with what I have, but I will surely give your ideal a play too, as that appears to be much simpler.
  4. O

    DSum With Multiple Criteria and Date Value

    Thanks guys!
  5. O

    DSum With Multiple Criteria and Date Value

    I am sorry, but you were right about the Table name. Thanks
  6. O

    DSum With Multiple Criteria and Date Value

    Problem Solved (Too many mistakes and Errors) Dim DisabilityChecks As Currency Dim UnemployementChecks As Currency Dim WorkersCompChecks As Currency Dim PayChecks As Currency DisabilityChecks = DSum("SS_Disability", "Income Activity", "CLIENT_KEY=" & CLIENT_KEY & " And...
  7. O

    DSum With Multiple Criteria and Date Value

    It doesn't work with Access 2010. I am getting what I need if I am using just the Client_Key criteria, but not when I add the Income_Period criteria.
  8. O

    DSum With Multiple Criteria and Date Value

    Concatenating DSum might be a problem for me, can you please offer an example?
  9. O

    DSum With Multiple Criteria and Date Value

    I am willing look into Subform, but I have come too far into this ideal not to try to get it to work.
  10. O

    DSum With Multiple Criteria and Date Value

    First problem, Access 2010 can't locate the Table with the " ", without it or with [ ] will work though. Second problem, once I took out the " ", I now get a Run-time error '2428': (You entered an invalid argument in a domain aggregate function)
  11. O

    DSum With Multiple Criteria and Date Value

    I think you have list separator errors with your solution. Thanks
  12. O

    DSum With Multiple Criteria and Date Value

    Can someone please tell me why I keep getting type mismatch error here? Dim DisabilityChecks As Currency Dim UnemployementChecks As Currency Dim WorkersCompChecks As Currency Dim PayChecks As Currency DisabilityChecks = DSum("[SS_Disability]", Income_Activity...
  13. O

    Occupancy Query

    I think I just did, :)
  14. O

    Occupancy Query

    I am not creating a table, the table is already done, I am to pull information from the table using query, and its very similar to the attached database. From my understanding, occupancy here is how many bodies occupied the house in a given month (i.e. Jan). Assuming all we have to work with...
  15. O

    Occupancy Query

    I am a little confused, so I thought I create a small database similar to what I am looking to get done here. I need help in putting some of what you guys are talking about into query, am a little confused. Please see attached Access Database.
  16. O

    Occupancy Query

    Thanks for the response. Think about your response, but that can't respresent the occupancy of the house, what if the same person that came in in January, came and left multiple times? Does that person count once or as many times at he/she came and left?
  17. O

    Occupancy Query

    I am having a big problem writing a query that will give the right answer to this problem. Here's my scenario, let say you have a house, and people are allow to go in and out of the house at anytime all year round, the only requirement is that their entry and exit date/time must be noted, and...
Back
Top Bottom