Duplicate Checking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the wizard that comes with Access to find duplicate.



John Daily said:
How would I code to check for duplicates for a particular field? I was
Click to expand...
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,
Click to expand...
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
Click to expand...
something? I have tried with a query and it just doesn't come out right.
 
Back
Top