View Single Post
  #2 (permalink)  
Old July 28th, 2006, 09:48 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What is a drop? What is a vehicle?

What is the query that is behind the report?

What you need to do is to create a report that does only one record per page. This is easy enough if the data is consistent. However, if it is not (various lengths) then you can run a report for each "drop" in your list box. Just enumerate them and run the report where "[Drop] = " & "'" & sDrop(i) & "'"

Need more info.


mmcdonal
Reply With Quote