Error 3070

B

burg

Hello,

When I try to run a report with a graph on it, it displays an error message:
The Microsoft Jet database engine does not recognize <name> as a valid field
name or expression. (Error 3070)

The help goes on about cross tab queries but I am using a select query. The
query works without a problem. The query is below:
SELECT DateDiff("d",[Estimated_Release_Date],[Actual_Release_Date]) AS
Delay, PN_Number.Estimated_Release_Date, PN_Number.Actual_Release_Date,
PN_Number.PN_Number, PN_Number.[Reason_for _delay],
Reason_for_delay.Reason_For_Delay
FROM Reason_for_delay INNER JOIN PN_Number ON Reason_for_delay.Reason_ID =
PN_Number.[Reason_for _delay]
GROUP BY DateDiff("d",[Estimated_Release_Date],[Actual_Release_Date]),
PN_Number.Estimated_Release_Date, PN_Number.Actual_Release_Date,
PN_Number.PN_Number, PN_Number.[Reason_for _delay],
Reason_for_delay.Reason_For_Delay
HAVING (((PN_Number.PN_Number) Between [Please enter the start of the range]
And [please enter the end of the range]));

The <name> part of the error mesage is [Please enter the start date of the
range]. If i remove the criteria it works but shows all of the data. I would
liike to show only a specified range.

The graph has delay as the y axis, PN number as the x axis and reason for
delay as the series name.

Thanks!!
 
Top