Showing "latest" date from a list of dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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?
 
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.
 
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...
 
Back
Top