|
| |
|
|
Bnugent
Posts: 257
From: Tampa Florida Tampa, FL USA
Status: offline
 |
SQL Code Not Working... - 1/8/2008 10:01:54
Actually, I have this working...
SELECT OSR, MAX(First) as First_Name, MAX(Last) as Last_Name, SUM(Sales) as T_Sales FROM osrsales WHERE ShipDate >= #::ShipDatefloor::# AND ShipDate <= #::ShipDateceiling::# AND Order_Type Like 'd%' GROUP BY OSR
The issue is when I want to sort by T_Sales like this:
SELECT OSR, MAX(First) as First_Name, MAX(Last) as Last_Name, SUM(Sales) as T_Sales FROM osrsales WHERE ShipDate >= #::ShipDatefloor::# AND ShipDate <= #::ShipDateceiling::# AND Order_Type Like 'd%' GROUP BY OSR ORDER BY T_Sales DESC;
I get error:
No value given for one or more required parameters
If I try to add where clause using T_Sales like this:
SELECT OSR, MAX(First) as First_Name, MAX(Last) as Last_Name, SUM(Sales) as T_Sales FROM osrsales WHERE ShipDate >= #::ShipDatefloor::# AND ShipDate <= #::ShipDateceiling::# AND Order_Type Like 'd%' AND T_Sales >= 3000 GROUP BY OSR
I get error:
No value given for one or more required parameters
Any thoughts...It has to be something simple...also, Sales and T_Sales is a currency field.
_____________________________
Brian---
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: SQL Code Not Working... - 1/9/2008 8:53:37
quote:
... AND T_Sales >= 3000 GROUP BY OSR
Did you try this?
... AND Sum(Sales) >= 3000 GROUP BY OSR
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
Bnugent
Posts: 257
From: Tampa Florida Tampa, FL USA
Status: offline
|
RE: SQL Code Not Working... - 1/9/2008 9:27:47
had to use:
SELECT Sales.OSR, Max([Outside Sales Rep].[First Name]) AS [First], Max([Outside Sales Rep].[Last Name]) AS [Last], Sum(Sales.[Total Sales]) AS Sales FROM Sales INNER JOIN [Outside Sales Rep] ON Sales.OSR = [Outside Sales Rep].OSR WHERE (((Sales.ShipDate)>=#12/1/2007#) AND ((Sales.Order_Type) Like ""d%"")) GROUP BY Sales.OSR HAVING (((Sum(Sales.[Total Sales]))>=3000)) ORDER BY Sum(Sales.[Total Sales]) DESC;
_____________________________
Brian---
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
