If the names of the tables and fields are those in the image, try this query:
Code:
SELECT qryUnion.CustomerName, qryUnion.InoiceDate, qryUnion.InoiceNumber, qryUnion.InoiceAmount, qryUnion.ReceiptDate, qryUnion.ReceiptNumber, qryUnion.ReceivedAmount
FROM (SELECT SalesTable.CustomerName, SalesTable.InoiceDate, SalesTable.InoiceNumber, SalesTable.InoiceAmount, "-" AS ReceiptDate,"-" AS ReceiptNumber,"-" AS ReceivedAmount, SalesTable.InoiceDate AS DateMove, 1 AS Priority
FROM SalesTable
WHERE SalesTable.CustomerName="New Fashion Dresses"
UNION SELECT ReceiptsTable.CustomerName, "-" AS InoiceDate, "-" AS InoiceNumber, "-" AS InoiceAmount, ReceiptsTable.ReceiptDate, ReceiptsTable.ReceiptNumber, ReceiptsTable.ReceivedAmount, ReceiptsTable.ReceiptDate AS DateMove, 0 AS Priority
FROM ReceiptsTable
WHERE ReceiptsTable.CustomerName="New Fashion Dresses") As qryUnion
ORDER BY qryUnion.DateMove, qryUnion.Priority;
otherwise correct the name of the tables and fields.