Error on a cross-tab query

  • Thread starter Thread starter Ted
  • Start date Start date
T

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...
 
Back
Top