how to export to excel?

  • Thread starter Thread starter Frederick Wilson
  • Start date Start date
F

Frederick Wilson

Hello,

I want to create a matrix from information in access.
We have several packing rooms, each room can only pack certain stuff.

RM1 RM2 RM3
PROD
A X X
B X X X
C X
D X X

How can I get this type of layout from
PROD RM
A 1
A 3
B 1
B 2
B 3
C 2
D 2
D 3
 
You don't have to export to Excel to get this. You can use a crosstab query
to get it in Access and then base a report on the crosstab query.
 
Back
Top