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!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Torren
-
Multi table Sum Query
Yer it was meant to be CostOfRepairs not CostOfBike Again. My fault been workin on theis database 20hours straight im knackerd. but i really want to get this sorted. But basically what needs happening is all the Hire income of the a bike Must be grouped and subtracted from the cost price and the...- Torren
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Multi table Sum Query
Ok the three tables involved are TblBikes containing information on the quadBikes in stock TblHires containing hire information with the forign key BikeID TblRepairs containing bike repair information with the forign key BikeID What i want to do is group all by BikeID and calculate the...- Torren
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
