Search results

  1. J

    Validation rule- Can't begin with 5

    I need to have a validation rule on a form that will not allow users to input any number that begins with a 5. The field is a text field because it requires 16 digits for each number. Is there a way I can stop the user from entering any number that starts with 5? Thanks for the help.
  2. J

    DateDiff

    Got it. Disregard the post.
  3. J

    DateDiff

    I am using a DateDiff formula like =DateDiff("m",[From],[To]+1). I keep getting a 0 for the result when the dates are in the same month. How can I get this formula to count the same month as 1? Thanks for the help.
  4. J

    Same criteria for 2 fields

    Sorry but I think that may have gone above me. In my situation where I have 2 date fields and I want them to return the same criteria from a form field that is not tied to a table only the query criteria, what would this look like? My field names are dtmDateReuqested and dtmDateCompleted.
  5. J

    Same criteria for 2 fields

    I am referencing 2 form fields where the user will input the dates they need. The 2 fields are not linked to a table, just the query criteria. How will this work? Also, what is the Me! in front of the text string do?
  6. J

    Same criteria for 2 fields

    I have 2 fields in my query, a date received and a date completed. In my query results I need to see all accounts that have a date received in the date range I specify and also accounts that have a date completed in the same range. Is this possible? I have been running into a few road blocks...
  7. J

    Query with or criteria on date range

    That is correct, however it is the same criteria. I need to see all account either received or completed in the same time frame. Is there a work around?
  8. J

    Query with or criteria on date range

    I have 2 fields in my query called dtmDateRequested and dtmDateRequestComleted. When I run my query I would like for it to pull in all accounts that have either a Request Date which I specify or also a Completion Date in the same range. I have tried using the Between [Enter Begin Date] for the...
  9. J

    Code help

    Sorry for the last post. I typed it incorrectly. I am getting a compile error of "Else Without If". I did modify the code you provided slightly however I was getting the same error with your code. Function DateDiffW(dtmDateRequested, dtmRequestCompletion) Const SUNDAY = 1 Const SATURDAY = 7...
  10. J

    Code help

    Function DateDiffW(dtmDateRequested, dtmRequestCompletion) Const SUNDAY = 1 Const SATURDAY = 7 Dim NumWeeks As Integer I took your code that you provided and modified it slightly. I am getting a Compile Error of "Else Without If". What does this mean? I was getting it with your code as well...
  11. J

    Code help

    I have the following code in a module that works perfectly is the dtmRequestCompletion field is filled in. In my case it will not always be filled in. How can I get this code to return a null value if the field does not have a value and also carry through with the other code for records that...
  12. J

    Crieria based on form

    Diregard the last thread. I got it to work. Thanks.
  13. J

    Crieria based on form

    Are you saying add this new field as a new query field and put the Is Null in the criteria? Not really sure I am following you.
  14. J

    Crieria based on form

    I have a query that has the criteria based on what is entered in a form. My syntax is >[Forms]![Index]![NoticeDate]. What I would like to happen is if data is entered in the form field the results that are greater than that date will be returned but if nothing is entered all values will be...
  15. J

    SumIIF with variables

    Thanks. When I put "" I meant a null value.
  16. J

    SumIIF with variables

    I have the following formula in a report that calculates the current balance if the Type Loss is 4. I also need this field to calculate totla loss if the type loss is 4U, 4F, or "". Is there anyway I can add these other variables in to get a grand total in this one field? Thanks...
  17. J

    Calculate only business days

    I have a date range of 1/01/2005 to 12/25/2005 for example. I need a formula to return the number of days between these dates excluding weekends. Basically I need to know how many business days are between these dates. Thanks for the help.
  18. J

    workdays

    I come to this forum because I have been given extremely useful help in the past from extremely intelligent and helpful individuals. Please do not waste yours and my time if this is the response you are going to provide. Thanks.
  19. J

    workdays

    I have a date range of 1/01/2005 to 12/25/2005 for example. I need a formula to return the number of days between these dates excluding weekends. Basically I need to know how many business days are between these dates. Thanks for the help.
  20. J

    # of months between 2 dates

    I have 2 dates such as 1/01/2004 and 1/01/2005. I need a formula that will calcualte the number of months between the 2 dates. Thanks for the help.
Back
Top Bottom