awwalker
02-01-2002, 09:33 AM
I want to format a field in a form or a report that shows only the last date entered. e.g.the last date a certain book was ordered
|
View Full Version : forms awwalker 02-01-2002, 09:33 AM I want to format a field in a form or a report that shows only the last date entered. e.g.the last date a certain book was ordered David R 02-01-2002, 09:58 AM The function you're looking for is Dmax(). One example is: =DMax("[DateBought]","[tableOrderDetails]","[OrderID] = " & [Forms]![Orders]![OrderID]) or something similar. HTH, David R |