Recent content by murali2611

It does not add the query that I have just added to the recordsourcce of the report.

DO I rewrite my query ?

I can only add 1 query to the record source of the report. How do I get the other values ?

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...

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...

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.

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...