Skip to Content
0
Former Member
Oct 03, 2011 at 06:35 PM

Conditionat display a most recent record

15 Views

Hello,

I'm a bit stuck with an urgent report and wondered if anyone could supply an idea.

I need to insert the most recent record with a jobNo<>u201Du201D and Qty <>0 into a subreport and display it . So in this date set as below, the fifth line should be inserted to subreport .

Thank you in advance!

Lin

PartNo Date JobNo Qty Balance

1111 9/10/11 0 5

1111 9/09/11 10 90

1111 9/07/11 9 2

1111 9/04/11 0 9

1111 9/03/11 123 1 110

1111 9/01/11 234 3 220

u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026