Deleting Duplicates

[Glowackattack]

Hi,
I have a table that has two fields, one is a transaction, the other is trasaction category, and in this case transaction category is always blank.

What i am doing is importing transactions from a text file, then looking up a transaction category off a lookup table for each transaction name, some of the transactions will not have a transaction category in that table, so those transactions are put into a form for the user to input the transaction category, then the transaction category lookup table is updated with the forms information for the next time the transaction comes through.

What i would like to correct is this, sometimes there are multiple transactions with the same name that dont have a transaction category on the lookup table, so it shows up multiple times on the form, and rather than having the user input the same transaction category multiple times on that form for each transaction, i want the table that the form is based off of to get rid of duplicate transaction names before the user see's it.

How can i accomplish this?? Thanks in advance for your help.

 

[wazz]

base your form on a query. build the query by putting both fields in the grid then click the 'Totals' button (or View->Totals). that's one way of "getting rid of" duplicates. check the query results with and without 'totals'. play around with that and post back.

 

[Glowackattack]

Perfect, using the "Group By" selection worked just fine for me...and i was able to just add that to the existing query. Cant beleive how simple that was, and that i didnt try it.

Thanks for your help.