Running a query when checkboxes are included

A

acomphenn

In the table I have a checkbox which showes if a file is still open or not.
Now I want to run a query showing which files are open & which files are
closed. How do I do that?
 
M

MGFoster

acomphenn said:
In the table I have a checkbox which showes if a file is still open or not.
Now I want to run a query showing which files are open & which files are
closed. How do I do that?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SELECT file_name, file_status
FROM table_name
ORDER BY file_status DESC

Assuming file_status is the "check box" (a bit data type [True/False]).
The query will show the open files at the top and the closed files at
the bottom. If you want to show just one or the other status, use
something like this:

PARAMETERS [Enter file status (True/False)] Bit;
SELECT file_name, file_status
FROM table_name
WHERE file_status = [Enter file status (True/False)]
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRK68YIechKqOuFEgEQK+bQCeM2W1Ewooxnmchy8UVJgffVcRWloAn3u+
8myVchWiZm5GrtYrz9DjDyXF
=hZSt
-----END PGP SIGNATURE-----
 
W

wormholealien

MGFoster said:
acomphenn said:
In the table I have a checkbox which showes if a file is still open or not.
Now I want to run a query showing which files are open & which files are
closed. How do I do that?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SELECT file_name, file_status
FROM table_name
ORDER BY file_status DESC

Assuming file_status is the "check box" (a bit data type [True/False]).
The query will show the open files at the top and the closed files at
the bottom. If you want to show just one or the other status, use
something like this:

PARAMETERS [Enter file status (True/False)] Bit;
SELECT file_name, file_status
FROM table_name
WHERE file_status = [Enter file status (True/False)]
Click to expand...

Then why put your mail address in dude?
 
A

acomphenn

Actually I have another question for you. In that same query I need the
following information off of the table:

File#
Employee Name
Date of Injury
Active File (which is a checkbox)
Insurance Notified (which is another checkbox)

When I go to run the query I leave the critera section blank for Active File
because I need to know if the file is either open or closed, but I then put
under critera for Insurance Notified *0* to get the ones that are not
reported to the ins co, but then in the Active File catergory the check box
is no longer there, it's replaced with 0's & -1's. How can I still keep the
check boxes for the Active Files, but still use the critera I put for the
Insurance Notified? I hope this makes sense. Thanks
 
A

acomphenn

Okay...I'm confused. Another person was able to help me with the below
question, but now I have another one. In that same query I need the following
information off of the 2005 Comp Table:

File#
Employee Name
Date of Injury
Active File (which is a checkbox)
Insurance Notified (which is another checkbox)

When I go to run the query I leave the critera section blank for Active File
because I need to know if the file is either open or closed, but I then put
under critera for Insurance Notified *0* to get the ones that are not
reported to the ins co, but then in the Active File catergory the check box
is no longer there, it's replaced with 0's & -1's now. How can I still keep
the
check boxes for the Active Files, but still use the critera I put for the
Insurance Notified? I hope this makes sense. Thanks

MGFoster said:
acomphenn said:
In the table I have a checkbox which showes if a file is still open or not.
Now I want to run a query showing which files are open & which files are
closed. How do I do that?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SELECT file_name, file_status
FROM table_name
ORDER BY file_status DESC

Assuming file_status is the "check box" (a bit data type [True/False]).
The query will show the open files at the top and the closed files at
the bottom. If you want to show just one or the other status, use
something like this:

PARAMETERS [Enter file status (True/False)] Bit;
SELECT file_name, file_status
FROM table_name
WHERE file_status = [Enter file status (True/False)]
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRK68YIechKqOuFEgEQK+bQCeM2W1Ewooxnmchy8UVJgffVcRWloAn3u+
8myVchWiZm5GrtYrz9DjDyXF
=hZSt
-----END PGP SIGNATURE-----
Click to expand...
 
Top