Prev: can I generate report showing which tables are used in which queri
Next: Display Query Results on top of a Form
From: BZboarding101 on 13 Jan 2010 13:26
ok i have this variable i am trying to use twice with different criteria and
it doesnt work help after i do with i want to count them
November: Date_mailed (Variable Name)
tblRecruitment2 (Table name)
Between #11/1/2009# And #11/30/2009# (Criteria)

October: Date_mailed
tblRecruitment2
Between #10/1/2009# And #10/31/2009#
From: golfinray on 13 Jan 2010 15:55
I think you want to count? If so, set the E looking button on your tool bar,
which turns on the Group ON feature then change the Group On to count.
--
Milton Purdy
ACCESS
State of Arkansas


"BZboarding101" wrote:

> ok i have this variable i am trying to use twice with different criteria and
> it doesnt work help after i do with i want to count them
> November: Date_mailed (Variable Name)
> tblRecruitment2 (Table name)
> Between #11/1/2009# And #11/30/2009# (Criteria)
>
> October: Date_mailed
> tblRecruitment2
> Between #10/1/2009# And #10/31/2009#
From: John W. Vinson on 13 Jan 2010 19:02
On Wed, 13 Jan 2010 10:26:01 -0800, BZboarding101
<BZboarding101(a)discussions.microsoft.com> wrote:

>ok i have this variable i am trying to use twice with different criteria and
>it doesnt work help after i do with i want to count them
>November: Date_mailed (Variable Name)
>tblRecruitment2 (Table name)
>Between #11/1/2009# And #11/30/2009# (Criteria)
>
>October: Date_mailed
>tblRecruitment2
>Between #10/1/2009# And #10/31/2009#

You may need to add the field (it's a *field*, not a *variable*; a variable is
something else!) to your query twice. What is actually the structure of your
table? What do you mean by "different criteria", and what exactly are you
trying to accomplish?
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: can I generate report showing which tables are used in which queri
Next: Display Query Results on top of a Form