Re: Summary Question in a Query

From: Graham Feeley (gfeeley36_at_optushome.com.au)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 18:23:51 +1000

Thanks Gary for your trouble and this thread never ceases to amaze me (busy
people willing to share their knowledge).

The =DLookup("CountOfTAB", "mg query query") work fine providing i hard
code the date in the first query.
in other words I took out "Forms]![FrmMG]![Combo3]" in the criteria column
and replaced it with a date i know is in the records eg: #10-04-04#.
and it works.
So I guess it is like an afterupdate I need somewhere ????? Maybe
Regards
Graham

"Gary Walter" <garylwpleasenospam@wamego.net> wrote in message
news:#W5c$PXIEHA.1220@tk2msftngp13.phx.gbl...
> "Graham Feeley" <gfeeley36@optushome.com.au> wrote
> > Sorry forgot to include the sql
> > SELECT TblMG.TAB, TblMG.POS
> > FROM TblMG
> > WHERE (((TblMG.POS) Between 1 And 3) AND
> > ((TblMG.DATE)=[Forms]![FrmMG]![Combo3]) AND ((TblMG.RQ_Rat)=1));
> >
> > SELECT Count([MG Query].TAB) AS CountOfTAB
> > FROM [MG Query];
> >
> > > Hi I have 2 Queries that counts the filtered data from a single table
> > which
> > > works fine.
> > > What I would like to know is how i can get a textbox on a form that
will
> > > give me the result of the summary query.
> > > I have posted the 2 queries below and i would appreciate any help in
this
> > > matter.
>
> Hi Graham,
>
> One method is to create an unbound textbox
> on your form, then in properties of this textbox,
> set Control Source to
>
> =DLookup("CountOfTAB", "nameofsecondquery")
>
> Please respond back if I have misunderstood.
>
> Good luck,
>
> Gary Walter
>
>
>