Yes/No Problem in Query

[Ken_C]

I'm having a problem getting my yes/no boxes to work in a query that i'm using. Instead of showing up as checkboxes in the query they show up -1 & 0.

Here is a snippet of my code. The MWS field in bold is supposed to be a checkbock but it just shows up as <tablename>.MWS in my query.

SELECT DISTINCT *
FROM [SELECT DISTINCT ......
FROM ABI_FINALZIP_37217_2 left JOIN ABI_FINALZIP_37217_3 ON ABI_FINALZIP_37217_2.UTLCID = ABI_FINALZIP_37217_3.UTLCID
union
SELECT DISTINCT ABI_FINALZIP_37217_2.UTLCID as OLD_UTLCID, ABI_FINALZIP_37217_2.OTCSID as OLD_CUSTID, ABI_FINALZIP_37217_2.UTCSNM as OLD_CUSTNAME, ABI_FINALZIP_37217_2.OTCLST as OLD_ACCOUNTCODE, ABI_FINALZIP_37217_2.SERVTYPE as OLD_SERVTYPE, ABI_FINALZIP_37217_2.IRRIGATION as OLD_IRRIGATION, ABI_FINALZIP_37217_2.DOMESTIC as OLD_DOMESTIC, ABI_FINALZIP_37217_2.MTR1 as OLD_MTR1, ABI_FINALZIP_37217_2.MTR2 as OLD_MTR2, ABI_FINALZIP_37217_2.MTR3 as OLD_MTR3, ABI_FINALZIP_37217_2.MTR4 as OLD_MTR4, ABI_FINALZIP_37217_2.UTCLAS as OLD_UTCLAS, ABI_FINALZIP_37217_2.MWS as OLD_MWS, ABI_FINALZIP_37217_2.WO, ABI_FINALZIP_37217_2.ABI, ABI_FINALZIP_37217_2.MAP_PARCEL_QUADRANT as OLD_MAP_PARCEL_QUADRANT, ABI_FINALZIP_37217_3.UTLCID as NEW_UTLCID, ABI_FINALZIP_37217_3.OTCSID as NEW_CUSTID, ABI_FINALZIP_37217_3.UTCSNM as NEW_CUSTNAME, ABI_FINALZIP_37217_3.OTCLST as NEW_ACCOUNTCODE, ABI_FINALZIP_37217_3.SERVTYPE as NEW_SERVTYPE, ABI_FINALZIP_37217_3.IRRIGATION as NEW_IRRIGATION, ABI_FINALZIP_37217_3.DOMESTIC as NEW_DOMESTIC, ABI_FINALZIP_37217_3.MTR1 as NEW_MTR1, ABI_FINALZIP_37217_3.MTR2 as NEW_MTR2, ABI_FINALZIP_37217_3.MTR3 as NEW_MTR3, ABI_FINALZIP_37217_3.MTR4 as NEW_MTR4, ABI_FINALZIP_37217_3.UTCLAS as NEW_UTCLAS, ABI_FINALZIP_37217_3.MWS as New_MWS, ABI_FINALZIP_37217_3.WO, ABI_FINALZIP_37217_3.ABI, ABI_FINALZIP_37217_3.MAP_PARCEL_QUADRANT as NEW_MAP_PARCEL_QUADRANT
FROM ABI_FINALZIP_37217_2 right JOIN ABI_FINALZIP_37217_3 ON ABI_FINALZIP_37217_2.UTLCID = ABI_FINALZIP_37217_3.UTLCID]. AS Update_Alias
WHERE OLD_UTLCID<>new_UTLCID OR OLD_CUSTID<>new_CUSTID OR OLD_CUSTNAME<>new_CUSTNAME OR OLD_ACCOUNTCODE<>new_ACCOUNTCODEOR Update_Alias.OLD_SERVTYPE<>new_SERVTYPEOR OLD_IRRIGATION<>new_IRRIGATION OR OLD_DOMESTIC<>new_DOMESTIC OR OLD_MTR1<>new_MTR1 OR OLD_MTR2<>new_MTR2 OR OLD_MTR3<>new_MTR3 OR OLD_MTR4<>new_MTR4 OR OLD_UTCLAS<>new_UTCLAS OR OLD_MAP_PARCEL_QUADRANT<>new_MAP_PARCEL_QUADRANT OR OLD_UTLCID Is Null OR NEW_UTLCID Is Nul;


Thanks in advance and hello I'm new

 

[raskew]

In the query-grid:
1) Highlight the yes/no field
2) Right-click to bring up a menu
3) Select Properties / Lookup then select Check Box from the Display Control drop-down.

HTH - Bob

 

[Ken_C]

I'm not getting a Display Control option in my menu. This is access 2003 btw if it makes a difference.