First Date / Last Date

F

flow23

I have a form based on a query.

everytime its requeried... the data changes in the form...
based on which at the bottom of that form I have a summary of it (text
boxes) name, Total (total of amounts), First date & last date...

I managed to get the name & Total.. but dont know.. how to pick up the first
date & last date from the query...
The query is sorted in ascending order. so the text box has to pick up the
date field from the first row and last row...

help
 
A

Allen Browne

Use DMin() and DMax() to display the earlest and most recent date.

For example, if the field is named Date1, and comes from Table1, you would
set the Control Source of the text box on your form to:
=DMin("Date1", "Table1")
 
H

harish

hello friend
i want know how to contact with girls site how i can talk to chat with girl
 
Top