I am creating a database for my job that deals with getting information about workload in different areas. What I want to do is bar chart the information in way that would compare each area but what I need to do first is create a query that has each area listed so I can chart each individual field. The comparison all comes from one field (Design Hours) which is located in my table and I need to come up with a new query that will divide the Design Hour field into three different areas. So to sum up what I want, basically I want to filter out the Design Hours field from the table and then in the query have Area1 field and the design hours for that area, Area2 field and the design hours for that area, and Area3 field and the design hours for that area. I am an intern and I am extremely new to access, this is my first database so can anyone help me please!!!!