IFF criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to design a query that only the names of people getting cards
would appear. It is indicated in the table and the form as a check in a
checkbox. I have tried IFF statements but do not know if it is correct to
use them, mostly because none are working
Thanks
 
You can but is not needed in your case. A check box is stored in a Yes/No
field as a -1 (minus one) or a 0 (zero). So all you need to do is sum the
absolute value.
SELECT Abs(Sum([YourCheckBoxField))
FROM YourTavle
GROUP BY YourCheckBoxField;
 
Oops! Mis-read post.
SELECT NameField
FROM YourTable
WHERE [YourCheckBoxField] = -1;

--
KARL DEWEY
Build a little - Test a little


KARL DEWEY said:
You can but is not needed in your case. A check box is stored in a Yes/No
field as a -1 (minus one) or a 0 (zero). So all you need to do is sum the
absolute value.
SELECT Abs(Sum([YourCheckBoxField))
FROM YourTavle
GROUP BY YourCheckBoxField;
--
KARL DEWEY
Build a little - Test a little


pamelia said:
I would like to design a query that only the names of people getting cards
would appear. It is indicated in the table and the form as a check in a
checkbox. I have tried IFF statements but do not know if it is correct to
use them, mostly because none are working
Thanks
Click to expand...
Click to expand...
 
Thank-you I'll try that

KARL DEWEY said:
Oops! Mis-read post.
SELECT NameField
FROM YourTable
WHERE [YourCheckBoxField] = -1;

--
KARL DEWEY
Build a little - Test a little


KARL DEWEY said:
You can but is not needed in your case. A check box is stored in a Yes/No
field as a -1 (minus one) or a 0 (zero). So all you need to do is sum the
absolute value.
SELECT Abs(Sum([YourCheckBoxField))
FROM YourTavle
GROUP BY YourCheckBoxField;
--
KARL DEWEY
Build a little - Test a little


pamelia said:
I would like to design a query that only the names of people getting cards
would appear. It is indicated in the table and the form as a check in a
checkbox. I have tried IFF statements but do not know if it is correct to
use them, mostly because none are working
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top