Report query?

[starlight]

Hi

I have a report based on a parameter query asking for a name to be entered for the output. The query on its own works fine but the report asks for the name twice?

Any ideas why?


Thanks.
S

 

[ColinEssex]

If the parameter is also on the report so that it shows in the report header for example - it must be absolutely identical to the one in the query or it will ask again.

Col

 

[starlight]

As far as I can see it looks the same?

In the query I have a field called 'name' which prompts the user to enter a name for the query. This 'name' field is on the report in the 'name header'.
So I'm not sure where im going wrong?

 

[ColinEssex]

I think you might be better off having the proper field for the name and put the parameter in the query criteria of the field like this

[Enter persons name]

It sounds like the report is getting confused somewhere, probably in the Sorting and Grouping.

Col

 

[Rich]

Name is a reserved word in Access and shouldn't be used as a field name. You should also enter the parameters via a form, just keep the form open while the Report is opening

 

[starlight]

That's what I have in the query.

When the report is run the dialogue box first displays 'Enter name' and then displays 'name'.

Anyway I've recreated the report based on the query and this time it seems to work fine!

Thanks for your help Col.