Nothing showing on max([date])

[Arlene]

I have a report which summarizes a bunch of work by month as produced by its
own query. I have another query that gives me the max date the work was done
by, as I could not get the first query to show the max date, kept getting the
aggregate function error. On my report I put a box in that shows max work
date. I have told the report to look in the correct query for the date, but
it will not return anything. The query runs fine and gives only that maximum
date, what can I be doing wrong?

 

[KARL DEWEY]

On my report I put a box in that shows max work date. I have told the
report to look in the correct query for the date, but it will not return
anything.

How did you 'tell the report'?

You can build a select statement the same as a query SQL statement to use in
the record source for the text box. Place an equal sign ( = ) in front of
the SQL statement.

 

[Arlene]

I did a select in my record source, stating= [Last Scale Date]![LAST SCALE]
in my source box. it actually is now looking for a parameter value, do I
have to tell it to run the query or something? Thanks

 

[KARL DEWEY]

What is [Last Scale Date]![LAST SCALE] refering to?
--
KARL DEWEY
Build a little - Test a little

I did a select in my record source, stating= [Last Scale Date]![LAST SCALE]
in my source box. it actually is now looking for a parameter value, do I
have to tell it to run the query or something? Thanks

report to look in the correct query for the date, but it will not return
anything.

How did you 'tell the report'?

You can build a select statement the same as a query SQL statement to use in
the record source for the text box. Place an equal sign ( = ) in front of
the SQL statement.

 

[Arlene]

Last scale date is the name of the query and Last date is where the max(date)
is.

What is [Last Scale Date]![LAST SCALE] refering to?
--
KARL DEWEY
Build a little - Test a little

I did a select in my record source, stating= [Last Scale Date]![LAST SCALE]
in my source box. it actually is now looking for a parameter value, do I
have to tell it to run the query or something? Thanks

On my report I put a box in that shows max work date. I have told the
report to look in the correct query for the date, but it will not return
anything.

How did you 'tell the report'?

You can build a select statement the same as a query SQL statement to use in
the record source for the text box. Place an equal sign ( = ) in front of
the SQL statement.

--
KARL DEWEY
Build a little - Test a little


:

I have a report which summarizes a bunch of work by month as produced by its
own query. I have another query that gives me the max date the work was done
by, as I could not get the first query to show the max date, kept getting the
aggregate function error. On my report I put a box in that shows max work
date. I have told the report to look in the correct query for the date, but
it will not return anything. The query runs fine and gives only that maximum
date, what can I be doing wrong?