RE: [MS_AccessPros] Report not working right yet.

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

To: MS_Access_Professionals@yahoogroups.com
From: xtintores@yahoo.com
Date: Thu, 14 Jul 2011 13:32:00 +0000
Subject: [MS_AccessPros] Report not working right yet.

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]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/