what is wrong with this database , or what is right way to do it ? Access 2010 RRS feed

  • Question

  • i have i databse like below :

    and i have a query to filter data according to a combobox from a form ( filter by job title , Equipment Type .... )like below :

    but now when i run the query , it get data for those employee which they have equipmentID , and im showing the result of the query on a report .. when there is more than one equipment for one employee .. it repeat the employee name ... ( may be this be solved by grouping with emplyee name ) , but if there is no record of equipment per some one .. it will not show this person if i filter it with job title ...

    any suggestion


    Wednesday, October 10, 2012 6:20 AM


All replies