"SELECT fldName FROM tblPass WHERE ReturnDate<NOW()"
that SQL statement will work to select the data in the fldName field of the members whose dates are expired. of course, change fldName to whatever info you want back from the table. if you build that query then you can use the form wizard to make a form that pulls the data from the query and displays. lemme know if that wasn't what you were looking for.
Originally posted by vilmarie85
I need to create a form that when I opening it a message show myself of all the persons that have in my tblPass whose ReturnDate of the material has expired. How I resolve these?