J
Jeannie
I have two tables: issues and position.
The issues fields are populated with the lookup value from the position table.
I want a query that will count each "oppose" and each "support" for each
issue in the issue table.
I tried the DCount like this in the criteria for the issue I'm trying to
count opposes:
DCount("*","issues","field='Oppose' ")
and get an error that says "can't find the 'field' you entered in the
expression"
Your help is much appreciated! thanks.
The issues fields are populated with the lookup value from the position table.
I want a query that will count each "oppose" and each "support" for each
issue in the issue table.
I tried the DCount like this in the criteria for the issue I'm trying to
count opposes:
DCount("*","issues","field='Oppose' ")
and get an error that says "can't find the 'field' you entered in the
expression"
Your help is much appreciated! thanks.