[AccessD] Report Subreport Problem X posted

Joe,
Just use the Report Wizard.  It is excellent for this type of report.
Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Thursday, February 21, 2008 4:43 AM
To: accessD at databaseadvisors.com
Subject: [AccessD] Report Subreport Problem X posted

Hi gang. Back for a few for some help please.

 

I am working on a report that for each product in an order will make a list
of what pieces need to packed and how many of them. 

 

I think my queries good.

 

qryPackListBuild1

 

SELECT tblNewOrders.OrderID, tblNewOrders.txtQBInvoice,
tblNewOrders.txtOrderBy, tblNewOrders.txtShipTo,
stblOrderDetail.cboSorderOurPartName, stblOrderDetail.txtsorderQuantity

FROM tblNewOrders LEFT JOIN stblOrderDetail ON tblNewOrders.OrderID =
stblOrderDetail.txtFKOrderID;

 

qryPackListBuild2

 

SELECT qryPackListBuild1.OrderID, qryPackListBuild1.txtQBInvoice,
qryPackListBuild1.txtOrderBy, qryPackListBuild1.txtShipTo,
qryPackListBuild1.cboSorderOurPartName, qryPackListBuild1.txtsorderQuantity,
tblOurParts.txtOurDesc, stblOurParts.txtPieceCode,
stblOurParts.txtPieceDesc, stblOurParts.txtPieceQuantity

FROM (tblOurParts INNER JOIN qryPackListBuild1 ON tblOurParts.cboOurPartName
= qryPackListBuild1.cboSorderOurPartName) INNER JOIN stblOurParts ON
tblOurParts.txtOurPartID = stblOurParts.txtOurPartID;

 

 

When I try to print (preview the report), it lists all the pieces for all
the products.  I want it to list product 1 and all the pieces to complete
the order for product 1. and then a new group for each additional product in
that order.

 

I have tried using the grouping but not gotten the results I want.

 

Any one have an idea?

 

TIA

 

 

Joe Hecht

Joe at anamericanjoe.us

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com