Search results

I am using DateDiff function to calculate the amount of time between two datetime fields. Every record returns #Error. Attempted to sort data and I get Invalid Call Procedure. I have tried to run the query on 3 different PC all with the same results. The function is coded like this...

The code below works as is but, I need help with the where clause. In its current state I am pulling data for a specific date. I would like to always pull data for the previous date or better yet be able to set it up so the end user can enter parameters for the time they wish. My apologies if...

It keeps saying there is a syntax error on line 3. Why? Thanks in advance Function AutoFail(CSEVal97, CSEVal98, CSEVal99) If CSEVal97 = 0 Then AutoFail = 0 Else AutoFail = CSEVal98 + CSEVal99 End if End function

I have read all that I can but, I can't find a resolution for dealing with Null values. Lets just say I have a text field. The records in the field would have either the letter A, the letter B, or nothing at all. I want my code to return Dog if the letter is A, Cat if the letter is B, Horse...

Using Access 97 Code that works is as follows: Function Category(arg As String) As String Select Case arg Case Is = "BNK" Category = "A" Case Is = "IND" Category = "C" End Select End Function Code that does not work is as follows: Function Category(arg As String) As String Select Case arg...

One of the fields in my table stores information like this: Northern Inbound Northern Outbound Northern Customer Relations West Retention West National Accounts Southern Retention Southern Billing These are divisions and groups. I want to drop the Northern, West (divisions) and only display...

I am using the code that follows to get a list of players names. I am putting the results (players names) in a text box on a form. I am referencing the text box in the criteria of my query. But, the query doesn't seem to notice the results. Why? Everything works the way I want except the...

I have a multiselect listbox with multiple columns. Column 1 is Player Name Column 2 is Player Salary I want to define which column is being used in my code since the Bound Column Property will only allow me to choose one. How do I do this. My code is below. Thanks Private Sub...

apparently doesn't work in VBA. Because it doesn't work this is the code I am using is below. My question: Is there a function similar to In() that I could use without having to Or arg = *** everytime? Thanks, /uh Function DivCSR(arg As String, arg2 As Double) As Double If arg = "CCM"...