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 you mean crystal report?

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