Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Aggregate help
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 30523 of 31576
Post > Topic >>

Aggregate help

by troy_lee@[EMAIL PROTECTED] Jun 16, 2008 at 07:28 AM

I am trying to count the total number of units for a given part number
that have a Priority rating of 1. Based upon some research, this is
what I came up with for my query. Access says that I have invalid
bracketing in the Select Distinct statement. The only brackets I
inserted were to delimit the table's field names. Access did the rest.
Also, Access created the second AS bracket group - [%$##@[EMAIL PROTECTED]
 I barking up the right tree or is my query statement way off base?
I am not sure where to put the WHERE clause and I don't understand the
bracketing error Access is giving.

Query Statement:
SELECT COUNT(*) AS ["Planned ****ps"] FROM [SELECT DISTINCT [Part No
2540] FROM RMAs WHERE [Priority] =1] AS [%$##@[EMAIL PROTECTED]
 GROUP BY [Part
No 2540];

Thanks in advance.

Troy Lee
 




 7 Posts in Topic:
Aggregate help
troy_lee@[EMAIL PROTECTED  2008-06-16 07:28:22 
Re: Aggregate help
"Keith Wilby" &  2008-06-16 15:50:10 
Re: Aggregate help
Salad <oil@[EMAIL PROT  2008-06-16 07:58:31 
Re: Aggregate help
troy_lee@[EMAIL PROTECTED  2008-06-16 08:10:01 
Re: Aggregate help
Salad <oil@[EMAIL PROT  2008-06-16 09:16:26 
Re: Aggregate help
lyle fairfield <lyle.f  2008-06-16 09:18:42 
Re: Aggregate help
troy_lee@[EMAIL PROTECTED  2008-06-16 11:35:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:20:58 CST 2008.