Summary Question in a Query

  • Thread starter Thread starter Graham Feeley
  • Start date Start date
G

Graham Feeley

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.
Regards
Graham
 
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];
 
Graham Feeley said:
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.
Click to expand...
Click to expand...

Hi Graham,

One method is to create an unbound textbox
on your form, then in properties of this textbox,
set Recordsource to

=DLookup("nameofsecondquery", "CountOfTAB")

Please respond back if I have misunderstood.

Good luck,

Gary Walter
 
sorry...

that should have been

set *Control Source* to

=DLookup("nameofsecondquery", "CountOfTAB")
 
Graham Feeley said:
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.
Click to expand...
Click to expand...

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
 
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 said:
Graham Feeley said:
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.
Click to expand...
Click to expand...

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
Click to expand...
 
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 said:
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 said:
Graham Feeley said:
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.
Click to expand...

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
Click to expand...
Click to expand...
 
Big thanks to Gary for his dedicated help.
I really appreciated it.
Regards
Graham

Gary Walter said:
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 said:
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 said:
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
Click to expand...
that
will
give me the result of the summary query.
I have posted the 2 queries below and i would appreciate any help
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top