Dmax syntax

[Gil Lopes via AccessMonster.com]

Hi fellas!
I have a report with no datasources (because of some subreports that are in
it).

I'm trying to insert a text box with the following statement:

=(dmax(field, query))

From what I know, it shoud work and return the max value from the query, but
it only returns "#Name?".

Any clues on this?
I' ve tryed to create another subreport with proper datasources and a "select
max" aproach, but the result was the same.

Any hints?

Many thanks,

Gil

 

[Duane Hookom]

A control source of
=(dmax(field, query))
won't work. You must use actual field and query/table names that enclosed in
quotes:
=DMax("[OrderDate]", "[Orders]")

 

[Gil Lopes via AccessMonster.com]

Many thanks Duane (once again).
That worked perfectly.

This is going well, finnaly.

Thanks,

Gil

A control source of
=(dmax(field, query))
won't work. You must use actual field and query/table names that enclosed in
quotes:
=DMax("[OrderDate]", "[Orders]")

Hi fellas!
I have a report with no datasources (because of some subreports that are

[quoted text clipped - 19 lines]

Gil