Search results

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.

Got it. Disregard the post.

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.

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.

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?

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...

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?

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...

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...

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...

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...

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

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.

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...

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

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...

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.

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.

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.

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.