Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

duplicate records

Status
Not open for further replies.
ALESLU76

ALESLU76

Technical User
Joined
Apr 25, 2002
Messages
2
Location
SI
I have one problem

I have my tabel with 2000 records.

but 1 record is duplicated. In table view is one record but when I make report from this table it make's me 2 records

why??
 
Sort by date Sort by votes
Do you have another table with a One-to-Many relationship that has two records in the Many end for that one main record ?




G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JayRo71
  • Locked
  • Question Question
Importing only unique records from excel tables
Replies
10
Views
1K
SkipVought
S
monkeysee
  • Locked
  • Question Question
Field to count specific records
Replies
3
Views
924
dhookom
dhookom
Brianfree
  • Locked
  • Question Question
Query to match records in two tables
Replies
4
Views
530
Brianfree
Brianfree
1DMF
  • Locked
  • Question Question
Audit trail - referential integrity on deleted records
Replies
8
Views
623
johnherman
johnherman
beth1959
  • Locked
  • Question Question
Seuquentially number portion of records
Replies
3
Views
404
beth1959
beth1959

Part and Inventory Search

Sponsor

Back
Top