Access 2003 report won't read query expression

[Kevinski]

I have a simple query which returns data between 2 dates based on parameters entered at runtime:

Between [Start] And [Finish]

But when I try to write a report based on this query and graph the results I get error messages

'The Microsoft Jet database engine does not recognise [Start] as a valid field or expression'

and a longer message suggesting reasons why...

Any idea what the issue is here?

 

[SkipVought]

Hi,

Is you field a REAL date or a string?

What is your SQL code?

What ACTUAL VALUES do you enter at run time?

Skip,
[sub]
[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE! [/sub]

 

[Kevinski]

Field is date/ time

SQL
SELECT Communication.[Communication Date], Communication.[No of Requests], Abbriviation.Description
FROM Communication INNER JOIN Abbriviation ON Communication.[Communication Category]=Abbriviation.[Abbr ID]
WHERE (((Communication.[Communication Date]) Between [Start] And [Finish]));

In the query I can enter d/m/y or dd/mm/yy or dd/mm/yyyy as my Start and Finish.

Any attempt to even open the report gives the error message - ie no chance to enter dates....

 

[SkipVought]

Does you query run APART from the report?

Skip,
[sub]
[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE! [/sub]

 

[Kevinski]

Yes absolutely

 

[bkpchs237]

Kevinski,
You state here that the query runs independently just fine. Then I suggest that the problem is with your report. You state that you are trying to write a report and graph the results. Am I to understand that you have placed a graph on the report? I have run into problems with them in the past. You might have better luck in one of the Access forums, but here's my 2 cents worth.
First, are you able to create a report based solely on the query itself with no graph? Does this run without incident? If so, then the problem is the chart/graph itself. You may need to setup the criteria variables that you are choosing [Start] and [Finish] on a form. Then run the report from a button on the form using the field references from the form with the stored values in your graph to complete the task.

Hope this helps.