Crosstab query

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

I want to build a crosstab query but I have more than 3
fields? Is there a way I can get around this. I need a
query that looks something like this.

SW_x SW_y East North
SW * * * *
SE * * * *
NW * * * *
NE * * * *

I tried just building a regular query with just those
items, but it produces a table with more results than what
I need. Any suggestions? Please help.
 
Dear CJ:

I have a strong feeling that your problem is more complex than what I
can tell from reading your posting. However, I cannot tell what this
complexity is from reading your message.

There is no particular problem with having a crosstab return more than
3 columns, such as the 4 you show here. The maximum is 255, like any
other query.

Then you say you have a "regular query" (simple SELECT?) that produces
more results than desired. In order to evaluate this statement, I
immediately think how I'd like to see the SQL of your query, sample
data for the query, and a description of what output the query
produces on this sample data that is NOT what is desired.

Sorry, but it looks like I cannot figure how to help you unless you
help me more first. OK?

I don't know if these two problems are really closely related, but if
not, I suggest you make separate posts for them. Then the responses
you get will be segregated into different threads, making it easier
for everyone to read. Often one of us will choose to respond to a
certain question but not another, due to our ability to understand the
question, our confidence in our ability to answer the question, and
just whether we're interested (we're unpaid volunteers anyway, so we
can afford to be picky).

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top