Duplicates in a form but not the query

[tcheck]

I was wondering what I am looking for. I have a form that is pulling data from a previous days transactions but most (not all) transactions are duplicated.

I created this form a couple of years ago and have not modified it for about 3 months and nobody else has made any changes. When I look at the query that the form is pulling nothing is duplicated. When the Recordset type is Dynaset (Inconsistent Updates) I get 94 records, when I change it to Dynaset, then I get the correct count of records of 80.



Thanks in advance.

[orange]

What is the recordsource of the Form?
What is the sql of the query?

Please post the sql.

[tcheck]

Here it is;

SELECT Wires_cmad.*, Wires_cmad.Type, WCType.WC_Name, [Symbol] & " " & [MMIDDisplayName] AS SymbolMMID
FROM Wires_cmad LEFT JOIN WCType ON Wires_cmad.WCType = WCType.WC_Type_ID
WHERE (((IIf([Forms]![frm_Recap]![CheckSymbol]=True,[Symbol] Is Not Null Or [Symbol] Is Null,[Symbol]=[Forms]![frm_Recap]![SelectSymbol].[Value]))<>False) AND ((IIf([Forms]![frm_Recap]![CheckMMID]=True,[MMID] Is Not Null Or [MMID] Is Null,[MMID]=[Forms]![frm_Recap]![SelectMMID].[Value]))<>False) AND ((IIf([Forms]![frm_Recap]![CheckProducer]=True,[ProducerID] Is Not Null Or [ProducerID] Is Null,[ProducerID]=[Forms]![frm_Recap]![SelectProducer].[Value]))<>False) AND ((IIf([Forms]![frm_Recap]![CheckDate]=True,[TradeDate] Is Not Null Or [TradeDate] Is Null,[TradeDate]=[Forms]![frm_Recap]![SelectDate].[Value]))<>False) AND ((IIf([Forms]![frm_Recap]![CheckType]=True,[WCType] Is Not Null Or [WCType] Is Null,[WCType]=[Forms]![frm_Recap]![SelectType].[Value]))<>False));

[orange]

Why would you do this?

SELECT Wires_cmad.*, Wires_cmad.Type,....

This Wires_cmad.* means all the fields in table wires_cmd , so there is no need to then itemize each field.
One or the other not both.

I'm not following your SQL and it means little to anyone unless they can see that [Forms]![frm_Recap] is open and the values that apply.

Can you tell us in plain English what the query is trying to do?

[tcheck]

Sorry, I was going to take out the search clauses. I had a cluse for the Wires_cmad.type so that is why it's in the query.

The query is just linking 2 tables togeather;

SELECT Wires_cmad.*, Wires_cmad.Type, WCType.WC_Name
FROM Wires_cmad LEFT JOIN WCType ON Wires_cmad.WCType = WCType.WC_Type_ID;