Help with Data Query

[Crosby87]

Hi All,

I am re-familiarising myself with access after a few years absence and i am struggling with a data query.

I am trying to analyse some benefits data for my employees but i have a couple of issues.

All of my imported data has come in "single lines" whereby each employee has an individual line for each of their benefits, as opposed to one with all their benefits.

is it possible to write a query that will allow me to do this?

 

[Joe4]

All of my imported data has come in "single lines" whereby each employee has an individual line for each of their benefits, as opposed to one with all their benefits.

That is actually how it should be in a normalized database.

If you want to display it all on a single line, there are a few ways to try and go about this:
1. Try using a Cross-Tab Query (you can Google "Access cross-tab query tutorial", if you are not familiar with this).
- or -
2. If you do not have a table that lists each member exactly once, create a query that lists each member exactly once. Then create a separate query for each benefit. Then create another query which links each benefit query to your member table/query and returns all the benefits in the order that you want.