check duplicated records from 2 table

[hr833]

I'm trying to check for duplicates from 2 table based on 2 fields. For example if the year and month is the same for table A and Table B then i will not import the record from Table B to Table A. But i have no idea how to do so. I have this and it has an error.

If DCount("*", "[All_part Report]", ([All_part Report].[Month] = [Temp].[Month])) > 0 Then
MsgBox "This is a duplicate"

Pleeeeaaase and THANK YOU!

[JKing]

The last parameter also needs to be a string.

If DCount("*", "[All_part Report]", "[All_part Report].[Month] = [Temp].[Month]") > 0 Then
 

[hr833]

The last parameter also needs to be a string.

If DCount("*", "[All_part Report]", "[All_part Report].[Month] = [Temp].[Month]") > 0 Then
 

Hey JKing

I used the code you give me but it returns me an error '2001'

Why is this so?

[JKing]

I think the problem is you're trying to draw data from more than one table within your criteria string.

My suggestion is to either use the built-in wizard for finding duplicate information in tables. You can get to the wizard by going to Tools > Analyze > Tables

The other idea is to write a query rather than use DCount.