Showing "latest" date from a list of dates

C

chip

I need to show the latest date from a list of programs with review dates
associated with them.

I only need to do this in a report "footer" and not associate any date with
it...

I am sort of "summing" the dates but only need the latest of all the entered
review dates to show up in the footer.

Ideas as to how I do this?

My text box is "IPv6_Capable_Date" from a query.

Is this enough info to get some help or do I need to provide more?

Thanks,
CCR
 
M

Marshall Barton

chip said:
I need to show the latest date from a list of programs with review dates
associated with them.

I only need to do this in a report "footer" and not associate any date with
it...

I am sort of "summing" the dates but only need the latest of all the entered
review dates to show up in the footer.

Ideas as to how I do this?

My text box is "IPv6_Capable_Date" from a query.
Click to expand...


Assuming that the date field in the query is named
IPv6_Capable_Date, the report footer text box can use the
expression:

=Mav(IPv6_Capable_Date)
 
C

chip

Thanks...unfortuneately, that didn't work.

I pasted your suggestion into my text box "control source" field and it adds
brackets around the name (IPv6...)

When I go to view the report, it pops up a dialogue box asking me to type in
"Mav"...

Thoughts?
 
M

Marshall Barton

Please excuse my lack of typing skills. That was supposed
to be Max, not Mav.

Access adds the square brackets areound most names so don't
worry about that.
 
C

chip

Yeah, I figured it out after looking at it a few times...no problem...I
appreciate your help...and it worked great!

Marshall Barton said:
Please excuse my lack of typing skills. That was supposed
to be Max, not Mav.

Access adds the square brackets areound most names so don't
worry about that.
--
Marsh
MVP [MS Access]

Thanks...unfortuneately, that didn't work.

I pasted your suggestion into my text box "control source" field and it adds
brackets around the name (IPv6...)

When I go to view the report, it pops up a dialogue box asking me to type in
"Mav"...
Click to expand...
Click to expand...
 
Top