Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2004
    Location
    Kent
    Posts
    59

    Unanswered: Queries / Report Problem

    Hi

    I currently have 2 Queries call "AUDIT_Module Testes Taken after 17/09/03" and "AUDIT_Logbooks Registered/Issued after 17/09/03"

    In the first query there are 6 fields, the most important one is the date field this has got the criteria >17/09/03 in so that it will show all module tests taken after that date.

    The second query has 3 fields the most important is the fileld "Registered by E-Mail" as this allows me to query all the people registered afer a certian date, >17/09/03.

    Both queries come from one main table called "Client Information" which has a another table joined to it via a relationship called "results"

    Now i need help to create a report that will show me a number/record count for:
    Module Testes Taken after 17/09/03
    and
    Logbooks Registered/Issued after 17/09/03

    I dont need any of the data generated by the query at the mo but i do need the numbers for an "at a glance summry" type thing for the audit.

    I will be adding 2 additional queries in the future, but if i can get the first 2 numbers onto the report i should be able to get any additional data onto the same report once i know hoe to do it.

    Thanks for any help given

    Icerat

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Build another query that does a count of the previous query ... Like:

    SELECT COUNT(*) FROM SomeQueryNameHere;
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jul 2004
    Location
    Kent
    Posts
    59

    Getting the, just a little further to go :-)

    Hi
    OK ive managed to get the query to count up the records for the 4 queries i wanted to count up by using union:

    SELECT Count(*) FROM [AUDIT_Module Testes Taken after 17/09/03]
    UNION
    SELECT Count(*) FROM [AUDIT_Logbooks Registered/Issued after 17/09/03]
    UNION
    SELECT Count(*) FROM [AUDIT_Candidates after 17/09/03]
    UNION
    SELECT Count(*) FROM [AUDIT_Candidates complete after 17/09/03];

    It desplays the data in 1 col is there a way to get it to display in serperate cols and can you name the cols as at the mo the col called EXPR1000

    Thanks for the help

    Icerat
    Last edited by Icerat; 07-02-04 at 09:41.

  4. #4
    Join Date
    Jul 2004
    Location
    Kent
    Posts
    59

    Question

    Hi

    It desplays the data in 1 col

    Is there a way to get it to display in serperate cols?

    Can you name the cols as at the moment the col called EXPR1000

    Any ideas guys

    Icerat

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Icerat
    Hi
    OK ive managed to get the query to count up the records for the 4 queries i wanted to count up by using union:

    SELECT Count(*) FROM [AUDIT_Module Testes Taken after 17/09/03]
    UNION
    SELECT Count(*) FROM [AUDIT_Logbooks Registered/Issued after 17/09/03]
    UNION
    SELECT Count(*) FROM [AUDIT_Candidates after 17/09/03]
    UNION
    SELECT Count(*) FROM [AUDIT_Candidates complete after 17/09/03];

    It desplays the data in 1 col is there a way to get it to display in serperate cols and can you name the cols as at the mo the col called EXPR1000

    Thanks for the help

    Icerat
    SELECT Count(*) AS SomeNameHere ...
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Jul 2004
    Location
    Kent
    Posts
    59
    Hi
    I Did The following:
    SELECT Count(*) AS MTT FROM [AUDIT_Module Testes Taken after 17/09/03]
    UNION
    SELECT Count(*) AS LRI FROM [AUDIT_Logbooks Registered/Issued after 17/09/03]
    UNION
    SELECT Count(*) AS C FROM [AUDIT_Candidates after 17/09/03]
    UNION
    SELECT Count(*) AS CC FROM [AUDIT_Candidates complete after 17/09/03];

    But i still just get 1 col with a title of MTT.

    Can you get the results in seperate cols like so:
    MTT LRI C CC
    55 58 9 5

    Is this possible

    thanks
    Icerat

  7. #7
    Join Date
    Jul 2004
    Location
    Kent
    Posts
    59
    Anyone know the answer
    Please

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •