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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

records are duplicating

Status
Not open for further replies.
dbpcar

dbpcar

Programmer
Mar 1, 2001
39
US
I have a problem with a a query that connects three tables-the record in the sale table is duplicating when there is more than one record in the cost table. I want all the cost figures to add and summarize for each sale.
 
Sort by date Sort by votes
Use a cross tab query or set up a select query to total. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
429
dhookom
dhookom
blueman124
  • Locked
  • Question
All records not showing in access table that is linked to sharepoint list
Replies
0
Views
348
blueman124
blueman124
Moss100
  • Locked
  • Question
Turn one to many relationship into single records 2
2
Replies
34
Views
1K
Moss100
Moss100
hudsma1
  • Locked
  • Question
how to make field value start with area code
Replies
2
Views
387
zandsc1
zandsc1

Part and Inventory Search

Sponsor

Back
Top