Error on a cross-tab query

[Ted]

I'm so close....

I have a cross-tab query built off a select query. THe
select query contains the following expression -

Switch(CDate([Enter Date])-[Net Date]<31,"Current",CDate
([Enter Date])-[Net Date]<61,"Over 30",CDate([Enter Date])-
[Net Date]>60,"Over 60")

When I run the cross-tab I get a Jet Database engine does
not recognize [Enter Date] as a valid field or expression,
however the select query runs without problem and prompts
me for the user date to input.

Any ideas as to where I'm missing the boat?

Thanks...

 

[Ted]

Nevermind, I think I got it figured-out