MS Access '97 Query Question

[warpdrve]

This is a 2-part question:

1. I have a series of data. For simplicity, let's assume it's a list of part numbers and locations stored. However, some pn's have multiple locations so they have multiple records. I need to construct a query which will provide me with a single record of a part number and multiple additional COLUMNS for each of the multiple locations. I'm thinking this is a crosstab query but can't quite figure it out. [If you reply to me via email, I might be able to construct a simple table as an example, and what I want to see as the result].

2. I am running Office XP on my office system along with Access '97 (installed in a separate directory). It's actually Office XP Pro but since we use Access '97 extensively and Access XP isn't downward compatible, I omitted the Access from the XP install and installed '97. My question is: Can I install Access XP on the same system and have both versions available to me (of course, keeping separate database files depending on the version)?

Thanks in advance for any assistance you can provide.

Regards,

/michael/

 

[Kevin123456]

In answer to part two of the question, I've never tried it with XP but I've certainly had Access 2000, Access 97 and Access from Office 4.3 happily co-existing on the same system by simply installing them in different directories on the file system.

 

[warpdrve]

Thanks for replying to part 2 ... now if I can only get someone to answer part 1.

Regards,

/michael/

 

[jmuscat]

I had a similar query from a user this morning ie. materials in different locations, and advised her to use an Excel pivot table.
Hope this helps