I have three records in a table with staff no 555,666,777 and I want to pass select query in data report for only staff no =666

please solve this problem

SELECT * FROM table WHERE staffno = 666

By datareport, do u mean crystal report?

If u're using crystal report, u can create a report with the staff no as its grouping. And then in the vb coding, u can type the report selection formula like
" {table.staffno}= '666' "