DCOUNT divided by DCOUNT 
Author Message
 DCOUNT divided by DCOUNT

Hi,

Still making no progress on this DCOUNT divided by DCOUNT
question. The function works in that it returns the first
percentage for the Day 1. I suppose the query is
attempting to divide the first % returned by every "days2-
30's" counts thus creating the overflow bc 30 divisions
would generate a double sized number. Therefore, the error
is in the denominator DCOUNT source ... ""[DDay" & rst!
[Day] & "]"" ...

While Not .EOF

strSQLCalc = "UPDATE [Shipped Via] SET [Shipped Via].
[Central Economy]   = Format(DCOUNT(""[Oracle PO ID
Reference2]"", ""[DDay" & rst![Day] & "]"",""[CDC Region
Name]='Central' AND [Carrier Cd]= 'AA2'"")/DCOUNT
(""[Oracle PO ID Reference2]"", ""[DDay" & rst![Day]
& "]"",""[CDC Region Name]='Central'""),'Percent') WHERE
[Shipped Via].[Day] = " & rst![Day] & ";"

db.Execute strSQLCalc, dbFailOnError

...

Thanks,

Hank



Tue, 24 May 2005 05:48:34 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Dcount function - need help with the criteria part!

2. dcount or counting records code?

3. Dsum and Dcount syntax

4. DCount question

5. Help with DCOUNT overflow problem

6. Dcount VBA syntax problem

7. sql dcount criteria syntax missing operator

8. Dcount

9. DCount

10. Creating statistical function using DCount

11. DCount problem

12. DCount - Problems

 

 
Powered by phpBB® Forum Software