Top Values

  • Thread starter Thread starter Question
  • Start date Start date
Q

Question

I have a report that has four subreports attached to it.

There are queries for each each section of the subreports:

The main report is for the actual project id
Then the four subreports are 4 separtate Comment/Notes
that go along with each project.

Now, I only want the top ten Comment/Notes for each
project.

How can I query this? In the criteria could I put
something?
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the TOP x operator in the SELECT clause. E.g.:

SELECT TOP 10 column1, column2, ... etc. ...

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

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

iQA/AwUBQDt/T4echKqOuFEgEQKfagCfSjFPuv8y8ec/J99/eEAS9k3mA6AAoMxq
BhahNSIzCYhuEY53+9BPXYnx
=2ov+
-----END PGP SIGNATURE-----


Question wrote:
 
Back
Top