var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: subquery using query wizards
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!
Do really need a Subqeury for that?
Something like this?
SELECT Expenditure.[all claims]
where Expenditure.[all claims]
=(select MAX (Expenditure.[all claims]) FROM Expenditure) ;
select MAX (Expenditure.[all claims])
Or do you mean something else
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.....
Last edited by awesomefennis; 12-05-02 at 11:11.