jods

Any access gurus out there ?

Is the following select too long / complex ?

SELECT building.unitary_authority AS UNITARY_AUTHORITY_E, building.national_park AS NATPARK, IIf(building.national_park=-1,community.national_park,Null) AS NATIONALPARKNAME, community.community, building.locality AS LOCAL, building.postcode AS POSTCODE, building.name, building.formerly_listed_as AS FORMALLYLISTEDAS, building.street_number, building.street_side, building.street, building.recno, v_listing.date_listed AS DATELISTED, last_amended.last_amended_date AS DATELASTAMENDED, building.easting AS EASTINGS, building.northing AS NORTHINGS, building.cadwref, v_listing.grade, building.location, v_listing.grouping_description AS description, building_text.history, building_text.reasons AS REASON, building_text.refs AS REFERENCE, building_text.interior, building_text.exterior, community.community_id
FROM (((building LEFT JOIN last_amended ON building.full_address = last_amended.full_address) LEFT JOIN community ON building.community = community.community) LEFT JOIN building_text ON building.full_address = building_text.full_address) LEFT JOIN v_listing ON building.full_address = v_listing.full_address
WHERE (((building.full_address) In ('Pig & Whistle,,Watton Road,,,,')));

nkh

I wouldn't have thought so, I assume it does work?

jods

That'll be a NO and a YES then ?

jods

Nah - Not as expected to work ! It doesn't return the description.

building.cadwref,v_listing.grade,building.location ,v_listing.grouping_description as DESCRIPTION

??

Confused - Oh yes

nkh

Can you send me sample database with the problem query? I'll take a look if that would help