Search results

  1. 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...
  2. 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...
  3. 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