Compare rows of a table

[olivetwist]

I pull transnational data from a table that store by Cycle Date. We use Current and Previous cycle date to compare and identify new entries each day. During the initial data query I flag certain rows as Error and then pull them into a second table as ERRORS. what i need to do is compare the rows in ERRORS.

Lets say my tables include the following fields:

company (name of source company)

account (account number)

amount (amount of transaction)

original date (date transaction was created)

description (notes)

cycle date (date transaction was processed)

cycle (P or C for previous or current)

I want to identify rows in the ERRORS table where (all fields&'C') matches (all fields&'P')

in other words, duplicate data not including the cycle identifier.

My ultimate goal is to display rows in the ERRORS table that are new today and not repeated from previous days cycle.

Any suggestions would be greatly appreciated.

[Digvijay_Singh · Accepted solution]

Try something like attached, you can use autonumber to create new flag field to identify duplicates.

[olivetwist]

That works for what I need. Thank you

[oknotsen]

If your question is answered, please flag the Correct Answer so others know the topic is done.

If something is still no clear, please tell us what part of this topic you still need help with .

[olivetwist]

I thought I had. my bad

[oknotsen]

All good .