[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Links 1
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___