Dmax syntax

  • Thread starter Thread starter Gil Lopes via AccessMonster.com
  • Start date Start date
G

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
 
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]")
 
Many thanks Duane (once again).
That worked perfectly.

This is going well, finnaly.

Thanks,

Gil

Duane said:
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
Click to expand...
[quoted text clipped - 19 lines]
Gil
Click to expand...
Click to expand...
 
Back
Top