Dmax syntax

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


--
Message posted via http://www.accessmonster.com

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]")

--
Duane Hookom
MS Access MVP
--

"Gil Lopes via AccessMonster.com" u13164@uwe wrote in message
news:55700beec7eb8@uwe...
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


--
Message posted via http://www.accessmonster.com

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

This is going well, finnaly.

Thanks,

Gil

Duane Hookom wrote:
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


--
Message posted via http://www.accessmonster.com