Results 1 to 6 of 6
  1. #1
    sk88 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    183

    Can we merge/combine 2 or more crosstab queries in to ONE Single query?

    Because I have more than 3 queries, it is really hard for me to manage. Therefore, I was thinking of having 3 crosstab queries to show in one single query. This way it will save my time from moving back and forth.

    Does anyone know how to do that? Is it possible? If so, how?



    Thanks!

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    all your queries have information in them from the same table? why not build one query that shows you what you want to start with then build the crosstab from that single query?

    Or are you saying you have multiple tables that all have the same information in them and you are building a duplicate query based on each table then trying to combine them?

  3. #3
    sk88 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    183
    Quote Originally Posted by rpeare View Post
    all your queries have information in them from the same table? why not build one query that shows you what you want to start with then build the crosstab from that single query?

    Or are you saying you have multiple tables that all have the same information in them and you are building a duplicate query based on each table then trying to combine them?

    hmm... I have like 3 to 4 crosstab queries. I was hoping that there is a way where I can combine those 3 to 4 cross tab queries in to one query view. so it will be like in one query, first few rows will be of the 1st cross tab query, then followed by the 2nd cross tab query and so on..

    These 3 to 4 crosstab queries consists of different information. I was just being lazy and thought there might be a way to view these queries together rather than having to click on to each query.

    Sorry, am I making sense here?

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    That doesn't really answer either of the questions I asked you're just restating what you want to do.

    You can show data from different queries with a UNION query, I've never attempted a union query from a crosstab query though.

  5. #5
    sk88 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    183
    Quote Originally Posted by rpeare View Post
    That doesn't really answer either of the questions I asked you're just restating what you want to do.

    You can show data from different queries with a UNION query, I've never attempted a union query from a crosstab query though.

    Sorry rpeare for not answering to your question earlier.
    My queries are from one table but of different rows.
    For example. I have tblNEW
    Fname Lname Address PostalCode Country Phone Date

    My first crosstab queries consists of like fname and date

    second query consists of Country and date

    and so on.



    I think what you suggested about the Union Query might be the solution.

  6. #6
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    Which brings me back to my original question, why, if all the data is coming from a single table, do you have 3 crosstab queries instead of combining the data you want to see in one query then viewing it, my guess is that your crosstab didn't want more than three row headers and you wanted more than that so you created 3 different crosstabs but my suggestion won't work (I don't think) for the type of combination you're looking for. Without an example of your database I don't know that I could offer a better solution though.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query to combine multiple queries
    By jortizz in forum Queries
    Replies: 4
    Last Post: 05-03-2011, 09:02 PM
  2. Replies: 8
    Last Post: 01-21-2011, 10:28 AM
  3. Combine Queries
    By Steven.Allman in forum Queries
    Replies: 9
    Last Post: 08-30-2010, 12:13 PM
  4. Combine 3 Queries
    By Logix in forum Queries
    Replies: 1
    Last Post: 06-10-2010, 06:03 PM
  5. Combine crosstab queries
    By thart21 in forum Queries
    Replies: 3
    Last Post: 05-03-2010, 10:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums