SQL QUERY HELP NEEDED BADLY

[daisypolly]

HI,

I am trying to make a query that will show how many due application are there for persons and to find that out I have to put some conditions for example the date should be greater than 2001/01/01 and the field act_type='DED' other restrictions which i know how to do and am doing them in the query below the problem that is occuring is that there are lot of repeating of the same name and I want the name to appear only once then the data for that person appears and then the next persons starts I thought i could this by using group by at the end for example GROUP BY EXAMINER at the end but that does not work please if some one can help me it will so much appreciated.What it looks like now is this:

http://bb.1asphost.com/irummaqsood/image333.JPG

"SELECT EXAMINER,APPLN,SUBCLASS,SECTION1,ACT_DATE FROM NEWLAW1.DBF WHERE ACT_TYPE='DED' AND SECTION1='E5' AND ACT_DATE>= #2001/01/01# AND EX_DATE1 IS NOT NULL ORDER BY EXAMINER ;


Thanks Daisy

 

[PHV]

And what is the expected result ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[daisypolly]

The result I am looking for looks like this...

Myslicki H2GH M2 1/13/2003
200356 F3GH 1/13/2004
200456 FK9H 1/11/2001

Something like this see the list in the URL has repeted names for Myslicki and this is happening for lots of others to so how can I make them appear once.

Thanks a bunch for replying.

Daisy

 

[PHV]

Seems much like a report issue than a sql prob.

 

[daisypolly]

Can this done by SQL?

 

[r937]

it can be done in sql, but it's really hard and really inefficient, and a lot easier to suppress the "repeated" values in your report than in sql

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)

 

[daisypolly]

Could you please show me how to do it with sql as i donot have any reporting software.Thanks for replying.

Daisy

 

[r937]

judging by the octothorps you used around your date, you are running microsoft access

access has a really good reporting function built in



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)

 

[daisypolly]

Thanks for replying. I donot have access the octothorps I used around date is because if i do it any other way it does not work in vb so that why i am using that. I would really like to know how to do this using sql.

Thanks
Daisy