Developer Forum

I'm trying to run a cross-tab query in Access 2000/XP. I need to pass two date parameters: StartDate & EndDate. When I try to pass these -- I get a message stating that the Jet 4.0 engine does not recognize the command. How do I pass these parameters to Access? I'm sending this over as a command from Crystal reports 9.0. Thanks in advance for any help/guidance

You must enter the data types of your parameters. Select Query|Parameters
and enter
[StartDate] Date/TIme
[EndDate] Date/Time
I'm not totally sure this will work with Crystal Reports but it works this
way in the much superior reporting of Access Reports ;-)

--
Duane Hookom
MS Access MVP




date parameters: StartDate & EndDate. When I try to pass these -- I get a
message stating that the Jet 4.0 engine does not recognize the command. How
do I pass these parameters to Access? I'm sending this over as a command
from Crystal reports 9.0. Thanks in advance for any help/guidance.