GET ONLY LAST DATE

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

Guest

I have a table in Access call RQ. In the queries design view of access, i
have a field called RQ_QTY_ISS from the RQ table. I would like to get only
the latest date of this field to show on the report, how can I do that? What
shall I put in Criteria on the query to only get the lastest date of this
field? Please help
 
No, it is not a date field. You are right I did not even think about that.
But my question is still the same. I need the latest date that points to
this field only. How can I do that? please...
 
No, it is not a date field. You are right I did not even think about that.
But my question is still the same. I need the latest date that points to
this field only. How can I do that? please...
Click to expand...

Unless you are recording the date in a field in the table, there is
simply NO way to do so. Access does not record the date when you enter
data into a table, unless you do so yourself.

John W. Vinson[MVP]
 
Back
Top