Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by murali2611
-
Show extra records in report
It does not add the query that I have just added to the recordsourcce of the report.- murali2611
- Post #17
- Forum: Microsoft: Access Reports
-
Show extra records in report
DO I rewrite my query ?- murali2611
- Post #15
- Forum: Microsoft: Access Reports
-
Show extra records in report
I can only add 1 query to the record source of the report. How do I get the other values ?- murali2611
- Post #14
- Forum: Microsoft: Access Reports
-
Show extra records in report
OK MY SQL QUERY : SELECT DISTINCT PurchaseOrders.PONumber, PurchaseOrders.SPCode, PurchaseOrders.Date AS PurchaseOrders_Date, PurchaseOrders.Net AS PurchaseOrders_Net, SuppInvoices.[Inv No], SuppInvoices.Date AS SuppInvoices_Date, SuppInvoices.Net AS SuppInvoices_Net FROM PurchaseOrders LEFT...- murali2611
- Post #12
- Forum: Microsoft: Access Reports
-
Show extra records in report
I have a similar problem, I have data from 2 tables in a LEFT JOIN. When I ccreate a REPORT I encounter few problems. Data in first table are shown even if they do not match anything in table 2, which is fine. I am trying to get the difference between 2 fields and where there is not...- murali2611
- Post #10
- Forum: Microsoft: Access Reports
-
Duplicative Values summed up in Report, but not shown
Can someone help me ? I need the Purchase order to appear just once, even if there are 2 invoices that make up for that purchase order.- murali2611
- Post #2
- Forum: Microsoft: Access Reports
-
Duplicative Values summed up in Report, but not shown
I have created a REPORT that matches a Purchase Order with an invoice. The subreport gives totals for each supplier for purchase orders and for invoices. A purchase order can be matched with more than 1 invoice. I get the problem when there are more than 1 invoice to be matched to the...- murali2611
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
