Query problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to to a query to gather a lot of account numbers (160), amd then do a
crosstab query. Is there a way to do this . Any help will be appreciated.
 
Create a first query which returns the data you want to use. Then make your
second query using the first query (instead of a table). There may be a
shorter way, but I'm not a crosstab person.

James
 
My problem is that I cannot put all account numbers in (too many). Each
account nunmber is 5 digits.
 
I want to to a query to gather a lot of account numbers (160), amd then do a
crosstab query. Is there a way to do this . Any help will be appreciated.
Click to expand...

Depending on what's in the crosstab that may be too many fields!

Two suggestions:

Use a criterion of

IN ("12345", "41412", "31247", "45127", ... <etc>)

If that give the Query Too Complex error or fails otherwise, create a table
with just one account number field; fill it with 160 rows of the desired
account numbers; and join it to your other table.

John W. Vinson [MVP]
 
Hi John

I do not think I am explaining this correctly. In the query I want to pull
out of a table account numbers, in the criteria when I go to put in account
numbers I can only go so far then it will not allow me to add any more
account numbers, is there a way to add more account numbers so that I can get
all of them? Thank you for taking the time to reply to me.
 
Hi John

I do not think I am explaining this correctly. In the query I want to pull
out of a table account numbers, in the criteria when I go to put in account
numbers I can only go so far then it will not allow me to add any more
account numbers, is there a way to add more account numbers so that I can get
all of them? Thank you for taking the time to reply to me.
Click to expand...

Yes, there is. There are two, in fact. I suggested them both in my previous
message.

Did you try my suggestions?

John W. Vinson [MVP]
 
I finally got it. Thank youi
--
thank you mac


John W. Vinson said:
Yes, there is. There are two, in fact. I suggested them both in my previous
message.

Did you try my suggestions?

John W. Vinson [MVP]
Click to expand...
 
Back
Top