Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    8

    Post Unanswered: subquery using query wizards

    Hi,

    I am trying to use subquerys using the wizards in access - you know the cure interface where you can just drag and drop the relevant tables and fields you need to report on.

    Withouht going in to too much details ...here is the story.

    I need to get figures from a table called Expenditure, but it has values for all claims - whereas I only need the expenditure for latest claim (i.e. highest value).

    I want to know how to do this in the wizard - i believe you need to use subqueries.

    If anyone could help - much appreciated!

    Thanks!

    Fennis

  2. #2
    Join Date
    Nov 2002
    Location
    The Netherlands
    Posts
    61
    Do really need a Subqeury for that?

    Something like this?

    SELECT Expenditure.[all claims]
    FROM expenditure
    where Expenditure.[all claims]
    =(select MAX (Expenditure.[all claims]) FROM Expenditure) ;

    Or Just

    select MAX (Expenditure.[all claims])
    FROM Expenditure;

    Or do you mean something else

  3. #3
    Join Date
    Jul 2002
    Posts
    8

    thanks - but...

    thanks but i know how to write it in sql - i just don't know how to get the desired effect when using the wizard!

    I still need to know how to do sub queries using the wizard - so please cnan someone point me in the right direction.....

    any help?
    Last edited by awesomefennis; 12-05-02 at 12:11.

Posting Permissions

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