Split P-Card Transactions Query

[skaird]

Hey guys I'm currently conducting a company wide P-Card review for over 200,000 transactions. With that I'm trying to create a query to identify any "Split Transactions" - i.e. those that were done by the same person, on the same day, to the same merchant.



Any help would be greatly appreciated!

Thanks,
DJ

[pbaldy]

Try creating a totals query that groups on those 3 fields and counts one of them. Put a criteria of

>1

on the count field.