"""Stefan Hoffmann ÐÉÓÁÌ(Á):
"""
hi Victoria,
Without the SQL of your query and the code it is not that easy to guess.
So post them.
mfG
--> stefan <--
Dear Stefan, thank you so much for your help! Sorry to trouble you !!
My query "FinalXXMissed" consists of several subqueries and tables.
1. Code for "FinalXXMissed" is
"SELECT operators!OperatorID AS ID, XMissed.TAP, operators!Name AS
îÁÚ×ÁÎÉÅ, [pasporta sdelki]![Debitor No] AS äÅÂÉÔÏÒ,
XMissed!Period AS ðÅÒÉÏÄ, XMissed!Amount AS [óÕÍÍÁ SDR]
FROM (XMissed INNER JOIN [pasporta sdelki] ON XMissed.TAP = [pasporta
sdelki].TAP) INNER JOIN operators ON XMissed.TAP = operators.TAP;"
2. Query XMissed code is
SELECT Xamounts.TAP, Xamounts.Period, Xamounts.Amount, Rates.RURSDR
FROM (XReceived RIGHT JOIN Xamounts ON XReceived.TAPper =
Xamounts.TapPer) INNER JOIN Rates ON Xamounts.Period = Rates.Period
WHERE (((XReceived.TAPper) Is Null));
3. Query Xamounts code is
SELECT AmountsIn.TapPer, AmountsIn.Period, AmountsIn.Amount,
AmountsIn.TAP
FROM AmountsIn
WHERE (((AmountsIn.Period)=[]));
4. Query XReceived code is
SELECT operators.Name, [pasporta sdelki].[Debitor No],
Invoices.OperatorID, Invoices.TAPName, Invoices.TAPper,
Invoices.InvoicePeriod, operators.TAP3
FROM [pasporta sdelki] INNER JOIN (operators INNER JOIN Invoices ON
operators.TAP = Invoices.TAPName) ON ([pasporta sdelki].TAP =
Invoices.TAPName) AND ([pasporta sdelki].TAP = operators.TAP)
WHERE (((Invoices.InvoicePeriod)=[]));
Sorry, I do not know how to explain else...... The goal is to identify
the records which ARE in table AmountsIN and not presented in table
invoices.....
Really appreciate your assistance....
Victoria