Passing date parameters to an Access cross-tab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


Greg Busby said:
I'm trying to run a cross-tab query in Access 2000/XP. I need to pass two
Click to expand...
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.
 
Back
Top