how to export to excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frederick Wilson - 31 Mar 2005 00:13 GMT

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

Reply to this Message

PC Datasheet - 31 Mar 2005 01:16 GMT

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.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> Hello,
>
[quoted text clipped - 18 lines]
> D 2
> D 3

Reply to this Message

Frederick Wilson - 31 Mar 2005 01:29 GMT

Well thanks!

I'll surly check that out tomorrow.

> 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.
[quoted text clipped - 27 lines]
>>D 2
>>D 3

Reply to this Message