Duplicate Checking

[John Daily]

How would I code to check for duplicates for a particular field? I was think of an increment counter with an if..then...else statement. I just don't know how to code it properly

I have four fields that I need to look at, acct_num, denial_date, total_charges, acct_bal. I need to cycle through the acct_num field for a particular month (denial_date) and add up the total_charges and acct_bal fields for those specific accounts

Am I making this too difficult? Is there an easier way using a query or something? I have tried with a query and it just doesn't come out right

TIA

John

 

[Phil Hunt]

Use the wizard that comes with Access to find duplicate.

How would I code to check for duplicates for a particular field? I was

think of an increment counter with an if..then...else statement. I just
don't know how to code it properly.

I have four fields that I need to look at, acct_num, denial_date,

total_charges, acct_bal. I need to cycle through the acct_num field for a
particular month (denial_date) and add up the total_charges and acct_bal
fields for those specific accounts.

Am I making this too difficult? Is there an easier way using a query or

something? I have tried with a query and it just doesn't come out right.