Help to Retrieve Previous Record

G

G. Wolfe

I have a subreport that will show all the history for one part. I want it to
only show the previous record of history. I thought about using criteria on
a date field.. something like <Date()-30 but the previous record may be
beyond 30 days.

I'm drawing a complete blank in how to achieve this... All help will be
greatly appreciated.

Thanks!!
Wolfe
 
Top