Query Results

  • Thread starter Thread starter Steven Phillips via AccessMonster.com
  • Start date Start date
S

Steven Phillips via AccessMonster.com

I have a query related to a table. One column is ID#, another column is efficiency, etc. I wish to run a query by selecting various ID#'s. When I put the ID#'s in the criteria, I seperate them with a comma. I can get a single ID# input to run but when I put several it does not work.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the Criteria box put

In (1, 2, 3, 4)

Where 1, 2, 3, 4 are your ID numbers.

If you are using strings instead of numbers delimite each string item
with quotes:

In ('1', '2', '3', '4')


--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQflvboechKqOuFEgEQLJvwCgs9t4EnqoDgCGAtSKnJt949dzkdQAn0P8
1VCaRipalNvbK3FkWMS2Pn5P
=BYWm
-----END PGP SIGNATURE-----
 
Thanks Chris,
SELECT DISTINCTROW [TOTAL SUM].[ID#], Sum([TOTAL SUM].pcs) AS SumOfpcs, Avg([TOTAL SUM].[s-up eff]) AS [Avg Of s-up eff], Avg([TOTAL SUM].[pro eff]) AS [Avg Of pro eff]
FROM [TOTAL SUM]
GROUP BY [TOTAL SUM].[ID#]
HAVING ((([TOTAL SUM].[ID#])=13163));
 
"Steven Phillips via AccessMonster.com" <[email protected]>
wrote in message
I have a query related to a table. One column is ID#, another column
Click to expand...
is efficiency, etc. I wish to run a query by selecting various ID#'s.
When I put the ID#'s in the criteria, I seperate them with a comma. I
can get a single ID# input to run but when I put several it does not
work.

Please open your Query in SQL View (while the
Query is open in Design View, see the main
toolbar and select: View > SQL View). Copy
the SQL there, and post it back here as a
reply to *this* thread.


Sincerely,

Chris O.
 
Back
Top