When you state "field in the recordset", you aren't telling us which recordset. Each subreport has a record source. Your subreports typically use the link master/child to filter the records in the subreports based on a value in its parent report.
Please tell us the link master/child properties as they cascade to your subreports.
Duane Hookom
MS Access MVP
> From: xtintores@yahoo.com
>
> The thing is I have a field in the recordset that is actualy in one of the subreports because I need to filter the recordset by this field.
> Sent from my BlackBerry® smartphone
>
> -----Original Message-----
> From: Duane Hookom duanehookom@hotmail.com
>
> Since the addresses and other tables are in subreports, remove these tables from the record source of your main report. If you don't, you will be multiple duplicate records in your main report.
>
> Duane Hookom
> MS Access MVP
>
> From: xtintores@yahoo.com
>
> Ok, I'm still having problems with my report. I'm using the following query (qryCustomerRute) to populate the report:
>
> SELECT tblCustomers.IdCustomer, tblStatus.Status, tblCustomers.AccountNum, tblCustomers.CompanyName, tblCustomers.Notes1, tblAddresses.City, qryServices.ProxServ
> FROM tblStatus INNER JOIN (tblCustomers INNER JOIN (tblAddresses INNER JOIN (tblInventory INNER JOIN qryServices ON tblInventory.IdInventory = qryServices.IdInventory) ON tblAddresses.IdAddress = tblInventory.IdAddress) ON tblCustomers.IdCustomer = tblAddresses.IdCustomer) ON tblStatus.IdStatus = tblCustomers.IdStatus
> WHERE (((tblStatus.Status)=[ENTRAR STATUS]) AND ((tblAddresses.City)=[ENTRAR PUEBLO]) AND ((qryServices.ProxServ)=[ENTRAR MES]));
>
> In the report I'm using a sub report for the addresses and two sub reports inside the address, one for the contact people for that address and another for the inventory at the address.
>
> The problem is that with the query I'm using, if a customer has 6 inventory items (records), than that customer shows up 6 different times in the report.
>
> Excaclly how do I fix this?
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar