T
TRACY TVO
When creating a make table which contains numerous fields
and duplicate records, how can you analyze the data in the
make table for a specific column and remove the records
that you do not want retained?
EG Columns: FILE NO FILE SUB DOITYPE ACCT GRP
12345 A BPO CURR%
45985 B WI CURR%
207196 A BEFPEN CURR%
207196 A AFTPEN RENT%
What I need to be able to do is where the file no and file
sub are the same, I need to be able to make Access select
the record that has the Acct Grp value equal to RENT% and
not CURR%. However the catch is, this can only be done for
records that have the exact same File No and File Sub. For
File Nos and File Subs that occur only once as a record,
the value of CURR% is value and these records need to
remain in the table.
Any help you can offer would be greatly appreciated.
thanks,
Tracy
and duplicate records, how can you analyze the data in the
make table for a specific column and remove the records
that you do not want retained?
EG Columns: FILE NO FILE SUB DOITYPE ACCT GRP
12345 A BPO CURR%
45985 B WI CURR%
207196 A BEFPEN CURR%
207196 A AFTPEN RENT%
What I need to be able to do is where the file no and file
sub are the same, I need to be able to make Access select
the record that has the Acct Grp value equal to RENT% and
not CURR%. However the catch is, this can only be done for
records that have the exact same File No and File Sub. For
File Nos and File Subs that occur only once as a record,
the value of CURR% is value and these records need to
remain in the table.
Any help you can offer would be greatly appreciated.
thanks,
Tracy