how do you create a union query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My table looks like this

Employee name Account Name Org Number

test 1 test 1
test 1 test58 1
test 2 test 11 5
test 2 test15 6

When I create a access page I want it to look like this


Record 1

Employee name test 1

Account Name Org Number
test 1
test 58 1

Record 2

Employee name test 2

Account Name Org Number
test 11 5
test 15 6
 
Your question has been answered by others in response to your other posts.

However, given your table data, I don't quite see how a UNION query would be
very helpful.

It looks more like a simple report formatting issue: EmployeeName in a
GroupHeader (with page breaks on changes to simulate "records"?),
AccountName and OrgNumber in the Detail section.
 
Back
Top