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 Wanet Telecoms Ltd 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 Strongbow1980
-
Multiple Table Query
Thanks, I have changed the statement to this, but now get an Expected Paramaters:2 error - Is this something to do with the dates? I have tried it both with the dates enclosed in '#' characters and without. SELECT CostCentres.Description, Sum(OrderItems.Price) As TotalSpend FROM CostCentres...- Strongbow1980
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Multiple Table Query
I tried that by including the OrderHead.OrderDate field and OrderHead table in the SELECT statement, and adding WHERE OrderHead.PONumber = OrderItems.PONumber to join the tables, and then the date criteria. but get an error saying something along the lines of OrderHead.OrderDate not being...- Strongbow1980
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Multiple Table Query
I have a few tables, but need to get data from 3 of them in 1 query. The Tables are CostCentre, OrderItems and OrderHeader I need to run a query that will total the cost of all items purchased between certain dates for each cost centre. I can do this for all orders in the database using this...- Strongbow1980
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
