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

Hi,

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

Thanks,

Hank



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

4. AVG ERROR

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