Use Same Variable multiple times in a query with different criteri

  • Thread starter Thread starter BZboarding101
  • Start date Start date
B

BZboarding101

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#
 
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.
 
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#
Click to expand...

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?
 
Back
Top