T teiben Registered User. Local time Today, 17:32 Joined Jun 20, 2002 Messages 462 Oct 20, 2005 #1 I have a report in which I only want the last 5 records to display, for instances there way be 100, how can this be accomplilshed? I'm using a parameter query, I"ve been playing with Min / Max / First / Last and help, isn't much help
I have a report in which I only want the last 5 records to display, for instances there way be 100, how can this be accomplilshed? I'm using a parameter query, I"ve been playing with Min / Max / First / Last and help, isn't much help
T teiben Registered User. Local time Today, 17:32 Joined Jun 20, 2002 Messages 462 Oct 20, 2005 #2 thanks, but what is TOP 5 predicate (I'm using Access 97)