Hi,
Can anybody help me out..
I want a query that fetches for records based on criteria which has to
include a column represeting the count.
e.g. select ...,empno,ename from employee where basic>5000
result should be
s.no. empno ename
1 E001 xyz
2 E450 x1
3 E560 z1
..
like that..
thanks in advance
regards
access_MK
---------------------------------
New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/