Problem with Parametervalues pop-up in a report

[mzoeller]

I have to create an access report for tracking orders which is then send as a pdf.
To keep track of the generated reports I created a table (let's call it table a) with an index, a date and the name of the person submitting the report.

What I want to do now is adding the highest index of table a to the report.
I thought that


=Max([table a]![index])
would do the trick, but it gives me a pop-up asking for the parametervalue of [table a]![index].
What could be the problem?

thx in advance

[pbaldy]

I assume table a is not part of the report's source? If not, you'd need to use DMax().

[mzoeller]

just tried using DomMax (there was no DMax() )
=DomMax(index;"table a")

didn't work either but produced an #Error instead of a blank field ^^

[pbaldy]

Just for fun, try

=DMax("index", "[table a]")

[mzoeller]

it almost worked ^^

=DMax("[index]";"[table a]")
did the trick.

thx for the hints.