input form

S

steph

Probably a very easy thing to do but very frustrating to
me !
Can I create a form from a table that would take only the
latest record for each person per day and allow me to
input information for each person?
 
J

JohnFol

To return records where, for the given person, the date is the the latest,
base the form on a query. The query is a straight forward select, but you
use a criteria in the Date field to be something like
=DMax("DateFieldInTable", "TableName", "Person = " & PersonFieldInQuery)

If you want this "Per Day", you will have to extend the criteria, or change
tactics. Id suggest creating a query first that gets the latest time for a
given date, ie

SELECT People.Person, Format([DateEntered],"dd/mm/yyyy") AS Expr1,
Max(People.DateEntered) AS MaxOfDateEntered
FROM People
GROUP BY People.Person, Format([DateEntered],"dd/mm/yyyy");


You then use this as an input to a second query, matching the datetime field
(DateEntered) and the Person with the original table.


It might be worth posting the table structure, as I am making several
presumptions here. . .
 
Top