Hi,:)

     I am trying to run an report in the following table pls give me an idea ..!

  I am having an table like :
    Name of the Employee , Personal Computer, Laser printer , Imkjet printer , Scanner , UPS ect . and i have allready generated the report using query as form Employee name & by the Equipment ament name but now i want to take the report by the above mentioned datawise ..

   The problem is all the employee won't have all the equipments . some ill have laser printer by not inkjet .. just like that .. so what i want to generate is if an employee is not having an equipmet it should come blank & the report should generate for whole employee's .. Iam trying with me but any idea will make me easy & gaining ..

 Thank in Advance ,
pap raguv..

Can you give us an idea of what fields are in the Equipment table? Aside from that, the way to assure all employees are listed regardless of whether or not they have equipment is to use a left join instead of an inner join:

Employees LEFT JOIN Equipment ON Employees.ID = Equipment.EmployeeID

Ok i ill explain
 I got an table Employee Name , Room No. , Name of the Equipment (Personal Computer,Scanner,Laser Jet, Inkjet & Laptop), Make , Model , Remarks.
 And i have generated the Report by Employee Name wise & Name of the Equipment Wise . Now i want to generate as Employee Name , Name of the Equipment ,Remarks (i.e) when i generate the report first NAme of the Employee follows with Personal Computer ,Scanner ,Laptop and Below this Equipment the Make & model as to come and if some body is not not having the Equipment the that place should be blank..
  Did u understand if not just give me an reply i ill explian u.

 Thanks for ur reply..

Bye,
pap Raguv

It sounds like what you want to do is generate a report, in which the Sorting and Grouping is based on Employee Name, and then Equipment Name. To do that, create a report and add all the fields you need to it. Add Employee Name, and Equipment Name to the list in the Sorting & Grouping window, and make sure both have their own header. Drag the fields for those two into their respective headers, and you should be good to go.