Unknown error in Avg(TimeValue) Function 
Author Message
 Unknown error in Avg(TimeValue) Function


Dealing with Average of Time is tough. Is TimeValue and
format valid to use in VBA?

strSQL = "UPDATE [AvgTimeDaily] SET [AvgTimeDaily].
[Central Average Posted Time] = Davg(""TimeValue('format
('[Posted Date]',''Long Time'')')"",""[DDay" & rst![Day]
& "]"",""[CDC Region Name]='Central'"") WHERE
[AvgTimeDaily].[Day] = " & rst![Day] & ";"
db.Execute strSQL, dbFailOnError



Mon, 23 May 2005 02:26:16 GMT  
 Unknown error in Avg(TimeValue) Function
Mispelled a FieldName. Doh!

Tue, 24 May 2005 03:13:50 GMT  
 [ 3 post ] 

 Relevant Pages 

1. 80040e21 Error - Unknown function name in table level validation expression

2. Help needed: Runtime error 3085 (unknown function)

3. TimeValue function


5. aggregrate function error for avg & date diff & iif function combo

6. VB5 Error 50003 - Unknown Error

7. LEFT$ and UCASE unknown functions ???????

8. Unknown function name in table-level validation expression - (Now())

9. Returned Mail: Host unknown or User unknown...

10. converting unknown strings with Replace function?

11. Extracting data from unknown locations in unique files of unknown size

12. Functions that return arrays of unknown dimension


Powered by phpBB® Forum Software