Search results

I was within the query. But after banging around it for a good portion of the day it appears the issues was with the format portion. I had it like this: DateDiff("nn",[FIELD1],[FIELD2]) which did not work. I changed it to this: DateDiff("n",[FIELD1],[FIELD2]) and it did work. Kind of...

Thank you agin for your input. I am leaving work for today but will log in later tonight if you or anyelse comes up with anything. Or even another work around to calculate the difference in the two fields. Thanks, /uh

No, it isn't named that. The name currently is DB2.

The original field names were STARTDATE and STOPDATE. I thought that may be a problem and I changed it to STRTDATE and STPDATE. I also thought maybe there was something quirky with the data so I made a new table and made the field names DOG and CAT if the DATE in the name caused the issue...

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

thanks again

thank you...teaching myself at this time

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

Thank you so much. I think that was the only way I didn't try to get it to work. THANKS!!!!!!!!!!!!!!!!

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

If you take the result and multiply it by 1440, you will get the resulting minutes. In this case 45.

Thank you...it works /uh

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

got, i'm good to go thanks, /uh

Yep, that does open it up now. The error I am getting after running initially is that the object "BillyJo" already exist. I guess I can do a macro to delete it everytime? [This message has been edited by Ajayi32 (edited 06-21-2001).]

KDg, I have made progress. I am however having to copy the results from the text box into the SQL view of my query to run. I thought it would run the query using this code. What am I doing wrong? Thanks again. This is the code now Private Sub Command32_Click() Dim intSalary As Long...

thank you, i will try that and let you know what happens

just key in 7 to change your font size. the drop down only shows 8 but you can make it smaller by typing in the number you want. yes, you can just print out your query results by clicking the print button or, if access is giving you that much trouble you can always copy the results into an...