Hi - I am new here, I have researched the heck out of this and am coming up empty handed....and I have no clue how to do what I am trying to do. My quest:
Create one report from two tables where information has been entered
A little background: I own a home building company/lumberyard, some materials arrive custom order which are recorded on one table (PurchaseOrderMain) sorted by the customer name (combo box, predictive phrase) - the table includes fields: PurchaseOrder#, SupplierName, ProductDescription, CustomerName , OrderDate, Notes, Invoiced (check box), Invoice#, TotalCost, Quantity, SortCode etc......All custom orders for ALL customers is entered on this same table and sorted by the Customer Name.
Other materials from stock are entered on another table that are customer specific (is. John's Build (JohnHome) is a separate table from Rita's Build (RitaBuild) for stock items)
I want to create a report that brings the items from the PurchaseOrderMain table that relate to John's Build (John's name in the CustomerName field) AND all the items from the table JohnHome.
I want them grouped by SortCode which I can figure out myself but I am having trouble linking the tables and getting them together in a report.....I have created a query from the PurchaseOrderMain for CustomerName "John" only and that seems to work good but I still can't create a report from table+table or table+query.
Any help is greatly appreciated - if this seems impossible, I understand as I am about ready to throw in the towel anyways.
Thanks in advance.
Rae
Create one report from two tables where information has been entered
A little background: I own a home building company/lumberyard, some materials arrive custom order which are recorded on one table (PurchaseOrderMain) sorted by the customer name (combo box, predictive phrase) - the table includes fields: PurchaseOrder#, SupplierName, ProductDescription, CustomerName , OrderDate, Notes, Invoiced (check box), Invoice#, TotalCost, Quantity, SortCode etc......All custom orders for ALL customers is entered on this same table and sorted by the Customer Name.
Other materials from stock are entered on another table that are customer specific (is. John's Build (JohnHome) is a separate table from Rita's Build (RitaBuild) for stock items)
I want to create a report that brings the items from the PurchaseOrderMain table that relate to John's Build (John's name in the CustomerName field) AND all the items from the table JohnHome.
I want them grouped by SortCode which I can figure out myself but I am having trouble linking the tables and getting them together in a report.....I have created a query from the PurchaseOrderMain for CustomerName "John" only and that seems to work good but I still can't create a report from table+table or table+query.
Any help is greatly appreciated - if this seems impossible, I understand as I am about ready to throw in the towel anyways.
Thanks in advance.
Rae