Query question

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
Back
Top