Results 1 to 8 of 8
  1. #1
    samefilip is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    5

    Showing data from different queries

    Hi,
    I need put data from different queries in my report, but i want to see them in order: first all data from one query, then data from another query. Is there any way to do this?

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    create 2 sub report, one for each query

  3. #3
    samefilip is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    5
    but if you have big batch of data calculating this report takes too much time every time when you want run this repotr

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    I don't think sub reports make more calculations.

    If you have time-consuming calculation in you queries, any way they cost you long time unless you create temporary table for the result, then the report get data directly from the temp table.

    This solution is good for those the data don't change frequently in the source table, because once the source table is changed, you need to re-create the temp table to reflect the changes.

  5. #5
    samefilip is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    5
    Hello,

    Forget about this method for a moment (I know subreports are good approach, but not in my case). Maybe, is any way to create some code which force every field from different queries to show data one after another, for example:
    Query 1 has data: A1; A2; A3...
    Query 2 has data: B1; B2; B3...
    Query 3 has data: C1; C2; C3...
    and I need something like that:
    A1
    A2
    A3
    B1
    B2
    B3
    C1
    C2
    C3
    .
    .
    .
    Any suggestions?

  6. #6
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    use union query:

    select * from query1 union all select * from query2 union all select * from query3

    the condition is: you must have save number of fields and same field type in all three queries(tables).

  7. #7
    samefilip is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    5
    union query isn't working for me, because i have 20 different queries which different fields inside, for example:
    Pipe: line number; code; description; length; weight
    Elbow: line number; code; description; quantity; weight

  8. #8
    samefilip is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    5
    I think about something like possibility to expand field with data up to showing all data from one query and then showing data from another query etc.

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

Similar Threads

  1. Replies: 23
    Last Post: 02-09-2011, 10:56 AM
  2. Design view not showing data (Pivot Chart)
    By thestappa in forum Reports
    Replies: 0
    Last Post: 06-24-2010, 09:59 AM
  3. Replies: 2
    Last Post: 02-13-2010, 01:54 PM
  4. Replies: 2
    Last Post: 04-29-2009, 11:50 AM
  5. Data Not Showing in Reports
    By Delin in forum Reports
    Replies: 1
    Last Post: 01-26-2006, 08:53 PM

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