Let's play nice my friends.

rf44

WOW!!! Thank you for the very detailed post and the effort I know it took to creat it. It is very appreciated. It will take me some time todecifer all...

Thank you all for the very informative information. To be quite honest I do not work anywhere, well I don't work with databases. I am an auto repair shop owner...

I have put the project on hold for a bit. Need to work more with Access and understanding the form creation and how to create list boxes to select year,...

Ok Everyone thank you for your help. Maybe there is an easier way to do what I want to do. First let me explain what this is all about.

I am...

I am more interested in a GUI to enter data into the database. Rather than retrieving data from the database.

Never mind.Got it.

SELECT OrderID, SUM([Order Details].UnitPrice*[Order Details].Quantity)

AS 'Order Total', COUNT([Order Details].OrderID) AS 'Order Count'

FROM [Order Details]GROUP BY OrderID

Thank you.

Not too many people did. Thats why a lot of people answered the question wrong.

The SALE definitely confused me as well. I couldn't force myself to believe that it would be a typo. It goes to show we are all human. I should have...

The only one that works is number 3. I left out a comma at first and none of them worked. when I realized it I had already answered none...

Sorry everyone. The last query that I posted was the results that I wanted.

SELECT od.productid, od.orderid, so.custid, so.empid,od.discount, od.unitprice - pp.unitprice AS Profit FROM

Production.Products AS pp

JOIN

Sales.OrderDetails AS od

ON pp.productid = od.productid

JOIN

Sales.Orders AS so

ON od.orderid = so.orderid

ORDER BY od.orderid

ok let me rephrase I know how to do the query. the problem is I can't figure out how to get the negative numbers.If there is no profit it just...

Geoff A (1/12/2012)

---

verify that your roles are properly set.

start up SSMS and connect to the SSRS instance.

Under Security --> System Roles, verify that the System Administrator has the proper settings.

Under...