Query question

[Jeff]

I'm trying to convert an older Access database that was not designed
very well, into a more efficient version.

One of the things they did was to create a table with the same fields
repeated 6 times
Old Table
Baseline hours1
Volunteer Hours1
Baseline hours2
Volunteer Hours2
Baseline hours3
Volunteer Hours3
etc.

In the new version, it's just
Baseline hours
Volunteer Hours

I'm trying to write a query where the Old Table is used as the source.
I want 1 record in my query to be Baseline1, Volunteer1, then the 2nd
record to be Baseline2, Volunteer2.

Is there a way to do this in Access?

Thanks

Jeff

 

[Jeff Boyce]

Jeff

Do a search on "normalizing union query" in this newsgroup. Or write a
series of (?!6?!) queries, one against each table, each one appending to
your new table structure.


--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/