Thanks for the reply.

But PvsSunCount is from query qryPvsWeek_Crosstab and SunCount is from query qryWeek_Crosstab.

So both are pulled from different recordsets.

How does this change the code that you had sent. Here's the breakdown for clarification.

SunCount - rsWk - qryWeek_Crosstab
PvsSunCount - rsPvsWk - qryPvsWeek_Crosstab

It doesn't matter that they are from different recordsets.

However, I don't see the definition of SunCount or PvsSunCount in the sample code that you posted.

If these are defined at the top level of the server-side code; i.e.

<%
Dim SunCount

it should work... give it a try; check syntax because I didn't.

Joel

I'm getting an error on this line.

<td><div align="center"><% =pctDif("Mc")%></div></td>

Microsoft VBScript runtime
Type mismatch:'pctDif'

Did you define the Function?

Function pctDif(sItem)

Dim v1
Dim v2
Dim pctD

v1 = CDbl(SunCount(sItem))
v2 = CDbl(PVsSunCount(sItem))

If v2 = 0 then
  pctD = (v1-v2)/(v2 + 1e-6)
else
  pctD = (v1-v2)/v2
end if

pctDif = pctD

End Function


As I posted it to you???

Joel

If so, try this:

Function pctDif(sItem)

Dim v1
Dim v2
Dim pctD

v1 = CDbl(SunCount(sItem))
v2 = CDbl(PVsSunCount(sItem))

If v2 = 0 then
  pctD = (v1-v2)/(v2 + 1e-6)
else
  pctD = (v1-v2)/v2
end if

pctDif = Cstr(pctD)

End Function


J

I was finally able to accomplish this task within an MS Access Query. I had to create a join between Category, WkNo, and DOW.
Thanks for everyone's help.