Re: Summary Question in a Query

From: Gary Walter (garylwpleasenospam_at_wamego.net)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 08:58:14 -0500

Hi Graham,

Actually, yesterday I started a week's vacation
and decided to treat myself to a morning of trying
to help people on ng (w/o "work guilt").

I am not sure what the answer is....

If you want to take this off line (and you can
zip your db into a small enough file attachment!),
remove "pleasenospam" from my email address
and send with a full explanation of what you are
trying to do. I will try to help.

I don't need all the data/tables...make a copy of
your db and try to trim that down to what is pertinent
to your problem before you zip and send.

Thanks,

Gary Walter

"Graham Feeley" <gfeeley36@optushome.com.au> wrote
> 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
> > "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
> >
> >
> >
>
>