Yes/No boxes show -1 and 0

[rcollins]

When I made my list box (selector to find client data) my yes and no values show -1 and 0 not yes and no. Am I missing something?

[FishVal]

Hi, Collins.

-1 and 0 are actually the values stored in database representing boolean values True and False respectively (or Yes and No as you like).
I would like to suggest you to replace that Y/N field in your query - RowSource for your ListBox, with a computation based on that field.

Something like this.

SELECT ......, IIf(blnYesNoField, 'Yes', 'No') AS txtYesNoField FROM ....
 

Regards,
Fish

[rcollins]

Hi, Collins.

-1 and 0 are actually the values stored in database representing boolean values True and False respectively (or Yes and No as you like).
I would like to suggest you to replace that Y/N field in your query - RowSource for your ListBox, with a computation based on that field.

Something like this.

SELECT ......, IIf(blnYesNoField, 'Yes', 'No') AS txtYesNoField FROM ....
 

Regards,
Fish

Right now I have the RowSource set as qryActive where it pulls the Client name, Active and Employment consultant. I guess I am not sure where to add this

SELECT tblClient.ID AS tblClient_ID, tblClient.LastName AS tblClient_LastName, tblClient.FirstName AS tblClient_FirstName, tblClient.Active, tblStaff.ID AS tblStaff_ID, tblStaff.LastName AS tblStaff_LastName, tblStaff.FirstName AS tblStaff_FirstName, tblClient.EmploymentConsultant
FROM tblStaff INNER JOIN tblClient ON tblStaff.ID=tblClient.EmploymentConsultant
WHERE (((tblClient.Active)=True))
ORDER BY tblClient.LastName;
 

[FishVal]

Right now I have the RowSource set as qryActive where it pulls the Client name, Active and Employment consultant. I guess I am not sure where to add this

SELECT tblClient.ID AS tblClient_ID, tblClient.LastName AS tblClient_LastName, tblClient.FirstName AS tblClient_FirstName, tblClient.Active, tblStaff.ID AS tblStaff_ID, tblStaff.LastName AS tblStaff_LastName, tblStaff.FirstName AS tblStaff_FirstName, tblClient.EmploymentConsultant
FROM tblStaff INNER JOIN tblClient ON tblStaff.ID=tblClient.EmploymentConsultant
WHERE (((tblClient.Active)=True))
ORDER BY tblClient.LastName;
 

Ok.

I guess the field mentioned is tblClient.Active.
So make the following changes to the query.

SELECT tblClient.ID AS tblClient_ID, tblClient.LastName AS tblClient_LastName, tblClient.FirstName AS tblClient_FirstName,
IIf(tblClient.Active, 'Yes', 'No') AS txtIsClientActive,
tblStaff.ID AS tblStaff_ID, tblStaff.LastName AS tblStaff_LastName, tblStaff.FirstName AS tblStaff_FirstName, tblClient.EmploymentConsultant
FROM tblStaff INNER JOIN tblClient ON tblStaff.ID=tblClient.EmploymentConsultant
WHERE (((tblClient.Active)=True))
ORDER BY tblClient.LastName;
 

Though right now i don't see what you are trying to represent in your listbox as long as all fetched records will have tblClient.Active=True.

[rcollins]

Though right now i don't see what you are trying to represent in your listbox as long as all fetched records will have tblClient.Active=True.[/quote]

That worked great. Thank you. I need the data people to be able to see who is active and who is not. They have a checkbox that limits to active or expands to all. Yes and No work better than -1 and 0.

[FishVal]

You are welcome.

Best regards,
Fish