Edgar-
You say tblAddresses is related to tblCustomer, but you don't say how. I assume
it's many addresses for one customer. How is inventory and service related to
these two tables?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
rivera_vazquez_edgar
Sent: Wednesday, July 06, 2011 4:09 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Help with reports.
I'm still having problems making my report.
Here is my structure:
tblCustomer related to tblAddresses. Each address has a contact person and an
inventory (tblInventory) and each inventory has a service (qryService).
I need all this info on the report but I need to filter the info by two fields
in diferent tables/query. There is a table for Status related to tblCustomer
and a field for next service date in qryService.
I need, for example, every active customer with their address and contact person
and the inventory for that address, but only show customers with a next service
date of July wich is in a table called tblService related to the inventory
table.
I'm realy stuck, HELP!
Edgar
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar