----- Original Message -----
From: "Winter, Patrick" <pjw@...>
Sent: Friday, January 31, 2003 12:12 PM
Subject: RE: [Vantage] RB help!
> I think so. Join partbin and oprice with company and part number.
> Group & Sort by part, bin then Oprice.StartDate or Oprice.EndDate
> Supress record lines and pull down the price with a calculated field.
> Patrick Winter
> -----Original Message-----
> From: Mike Tonoyan [mailto:miket@...]
> Sent: Friday, January 31, 2003 1:59 PM
> To: email@example.com
> Subject: [Vantage] RB help!
> In one of my Report Builder Reports I need to join "PartBin" and "Oprice"
> tables, and need to select only the latest dates from "Oprice" records for
> each "PartBin" Part Number. Is it possible to do this in Report Builder?
> Mike Tonoyan / MIS Manager
> All American Products Co.
> 1135 Aviation Place
> San Fernando, CA 91340
> Tel.: 818-361-0059 Ext.: 246
> Fax 818-898-2236
> E-mail: miket@...
> Web: www.allamericanproducts.com