> > Looks like I'll have to use CAST(). You're right, it should
> > return an Int, but it's returning an integer.
> What are you looking at? An Int and an integer are the same thing, aren't
Sorry - I mistyped. I meant to type "numeric" above but typed "integer"
I queried the same table several times using different date criteria:
SELECT ClientID, count(access) AS JuneTots (MayTots, etc.) FROM MyTable
WHERE EntryDate >= "06/01/2003" AND EntryDate <= "06/30/2003"
Then I queried for May, then for April, etc.
Sometimes the resulting column in the answer table was an integer, other
times it was a numeric.
When I later tried to combine things back together, I had problems and ended
up having to manually restructure all of the columns to the same type. It
was quite a hassle.