last date in query

  • Thread starter Thread starter Lin Light
  • Start date Start date
L

Lin Light

I have a query based a field in our invoice table. We
have a recap date for city hall, we group our invoice by
two week time period to be sent to city hall. So we have
a field for invoice date and another for recapdate. Well
my query runs asking for sum of invoices against a P.O.
and it is to record the last recapdate associcated with
that P.O. Well I have LAST in the "TOTAL" row in the
query, but it is not displaying correct date it in the
report/query. My sum is correct but that last recapdate
is off. Any suggestions.
Lin
 
Lin said:
I have a query based a field in our invoice table. We
have a recap date for city hall, we group our invoice by
two week time period to be sent to city hall. So we have
a field for invoice date and another for recapdate. Well
my query runs asking for sum of invoices against a P.O.
and it is to record the last recapdate associcated with
that P.O. Well I have LAST in the "TOTAL" row in the
query, but it is not displaying correct date it in the
report/query. My sum is correct but that last recapdate
is off. Any suggestions.
Lin
Click to expand...

Don't use Last() and First(); use Max() and Min() instead.
 
Thank you much. That is what I needed.
Lin
-----Original Message-----


Don't use Last() and First(); use Max() and Min() instead.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

.
Click to expand...
 
Back
Top