How can I find duplicates?

[DLM]

Hello!

On the sample file I'm including, I've 3 fields:

Username

Date

Time

What I need is a calculation (or any other way) that marks records that are duplicated ON ALL THREE FIELDS.

For example, in the attached file, it would be record 5 and 6... And also record 19 and 20.

I need a calculation that marks all those duplicated records.

I do not have much experience in calculations so an easy explanation would be appreciated (or a copy & paste of the calculation better :-)

Best!

Danny

sample.zip

[comment]

It cannot be done with a calculation alone: you need to either perform a find for the duplicates, or define a self-join relationship matching on the duplicate value then count the related records. Either way, you'll need a calculation field concatenating the values, e.g.=

Username & "|" & Date & "|" & Time

Off topic:

If you're just starting with Filemaker, you'd be well advised to upgrade to at least version 7. The changes after version 6 are fundamental and you will have a lot to unlearn later.

[DLM]

Hi comment, look at the attached, I did the concatenation on a calculation field as you told me to, then I did a find for duplicates with "!" and it works perfect, so thank you very much.

Just one question:

Do you know why do the date & time are converted into weird numbers when the concatenation is done?

It must have a logic to it, just like to understand it.

Best!

Danny

P.S. Got it on the tip of FM 7.

sample.zip

[comment]

These are not weird numbers - they are dates and times converted to numerical values (the serial number of the date starting from Jan 1, 0001, and the number of seconds elapsed since midnight). I forget the conversion rules for version 6, but since it's consistent I don't think you need to worry about it.

[DLM]

I see what you mean, thanks!