Access 97 and Pivot Tables

[Daedalus]

Perhaps I am not quite understanding the limitations of Pivot Tables, but here's what im looking to do...(bear in mind I only have Office 97).

I have data arranged in the following format.

Agent, Set1, Set2, Set3

Bill, a, b, e
Harry, a, d, f
Anastasia, c, e, f

I am trying to create a query or otherwise that would allow me to ask: 'Who does 'e'? And it would report Bill and Anastasia as the values.

Is this something that can be accomplished or will I need to go into SQL?

 

[Norie]

Daedalus

Is this an Access crosstab query or an Excel pivot table?

 

[Daedalus]

Well that's the thing...im not really sure what I would need to use.

I wanted to see if there was a way to create an "intelligent" query contained within Access. I know eventually I will create a script I can run from a website with ASP or PHP, but for an immediate use I wanted something I could query and test to make sure everything was 'correct'.

 

[Norie]

What do you mean by an intelligent query?

If you want user input you could use parameter queries.

 

[Daedalus]

Well as far as I can tell the 'Query' tool in Access is basically when you say:

-Show me the primary keys containing variable y.

What I wanted to do is:

-Find all primary keys that have variable y in columns 5-20 and display thier names only.

Im probably not making much sense.