Arno
Many thanks for that. It worked and also gave the correct results in the
report.
Regards
"Arno R" <arracomn_o_s_p_a_m@tiscali.nl> wrote in message
news:424271ed$0$44091$5fc3050@dreader2.news.tiscal i.nl...
Andy, I think you need this to 'tell' Access about your parameters:
Use the query-menu, menu item Parameters, enter the criteria EXACTLY
as you use them (cut and paste is safest) and enter the data type.
--
Hope this helps
Arno R
"Andy Davis" <ad_davis@westnet.com.au> schreef in bericht
news:42422278$1@quokka.wn.com.au...[color=blue]
> Dear Arno
>
> I get the following error message " Microsoft Jet Database engine does not
> recognise Forms!Menu!Reppicklist as a valid field name or expression".
> The user would normally enter the parameter for the query via a form. I
> have
> tried just run the query on its own with the values typed directly into
> the
> query and this works ok when inserting the chart on the report and the
> values are correct. However as soon as it is run as a parameter query I
> then
> get the above error message.
>
> Many thanks in advance.
>
> "Arno R" <arracomn_o_s_p_a_m@tiscali.nl> wrote in message
> news:42418043$0$44109$5fc3050@dreader2.news.tiscal i.nl...
> "Andy Davis" <ad_davis@westnet.com.au> schreef in bericht
> news:4241704d@quokka.wn.com.au...[color=green]
>>I have developed a number of reports that are based on parameter queries
>> where the user enters criteria such as a date range and a sales rep say.
>> I
>> want to be able to show a graphical picture in the form of a bar chart
>> based
>> on the data within the report. Can I do this as when I have tried to
>> insert
>> a chart on the report it displays an error saying that it doeds not
>> recognise the parameter criteria. Am I right to assume that maybe a chart
>> cannot be produced if it has used parameter inputs from a parameter type
>> query?
>>[/color]
>
>
> Andy,
> Your assumption is wrong. Maybe Access has a problem to 'understand' the
> field-type of your parameters.
> -- Is your report showing records without the chart?
> -- Is your report with chart showing records when you don't use
> parameters?
>
> --
> Hope this helps
> Arno R
>
>[/color]
