If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Putting mult query to one to make report
I needed to make a report that shows how many records took how long to
complete so in the table there is a request date and a complete date and so I have a query set up to tell the date difference between them and then if it is 1 it will list it etc ten queries like that for records that took 1 day then 2 day etc, then I was trying to make a query that pulled all those queries and counted the amount of records in each query so there would be 10 fields to display the amount of record that took x amount of days, but that query doesn't work right it will only pull the info if the amount of records in each of the 10 query is the same then it will display 1 for all of them but if any are different it won't pull that, can anyone give me a hand? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Report based on crosstab query - problem printing | Malcolm P | Setting Up & Running Reports | 5 | October 1st, 2004 09:42 PM |
Report based on crosstab query - problem printing | Malcolm P | General Discussion | 2 | September 27th, 2004 03:53 PM |
Report Based Upon Parameter Query with Form References | Vincent DeLuca | Setting Up & Running Reports | 4 | July 19th, 2004 01:55 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |