<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:st="" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:Z="urn:schemas-microsoft-com:"><head><META content="text/html; charset=utf-8" http-equiv="Content-Type">
<META content="text/html; charset=utf-8" http-equiv="Content-Type">
<STYLE TYPE="text/css">
<!-- /* Style Definitions */ p.49a98bb2-7ee8-4c5f-8a0f-561c82c6d7b1, li.49a98bb2-7ee8-4c5f-8a0f-561c82c6d7b1, div.49a98bb2-7ee8-4c5f-8a0f-561c82c6d7b1, table.49a98bb2-7ee8-4c5f-8a0f-561c82c6d7b1Table {margin:0cm; margin-bottom:.0001pt;}div.Section1 {page:Section1;}-->
</STYLE>
<meta content="text/html; charset=utf-8" http-equiv=Content-Type><meta content="Microsoft Word 12 (filtered medium)" name=Generator><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><BODY STYLE="background-color: #ffffff">
<P>
<P CLASS="49a98bb2-7ee8-4c5f-8a0f-561c82c6d7b1" STYLE=" margin-bottom:5px;">
<div class=WordSection1><p class=MsoNormal>I have opened an Access table via an ODBC connection. This has allowed me to open the attribute table up in QGIS. I have then done a join to join my attribute and polygon data together. I can style the data using the joined fields, and they all show up in the attribute table and the identify tool. However I cannot use these fields in a query. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If I use the query builder the fields show in the fields list, and the values from the fields show in the field list. However all of my queries return no results.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Am I missing something here?<o:p></o:p></p></div></P><P STYLE=" margin-top:5px; margin-bottom: 10px">
<SPAN STYLE="font-family: 'Verdana','sans-serif'; color: #00227c; font-size: 10pt">
<STRONG>James Stott</STRONG>
<SPAN STYLE="font-size: 8pt">BSc (Hons) MSc</SPAN> |
Senior Professional<BR>
<SPAN STYLE="font-size: 8pt"><B STYLE="font-weight: bold">Nicholas Pearson Associates </B> | 30 Brock Street | Bath | BA1 2LN<BR>
<B>T:</B>
01225 445548
| <B>M:</B>
-<BR>
<A HREF="http://www.npaconsult.co.uk/" STYLE="font-family: 'Verdana','sans-serif'; color: #00227c; font-size: 8pt; text-decoration: none;"><STRONG>www.npaconsult.co.uk</STRONG></A>
</SPAN>
</SPAN>
<BR>
<BR>
</P>
<P>
</P>
</P>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" STYLE="border: none; outline-style: none; border-collapse: collapse; padding: 0;
margin: 0;" WIDTH="700">
<TR>
<TD>
<A HREF="http://www.npaconsult.co.uk/" STYLE="outline-width: 0; border-collapse: collapse; text-decoration: none; outline-style: none;
border-style: none; margin: 0; padding: 0;">
<IMG ALT="Nicholas Pearson Associates, Logo" BORDER="0" SRC="cid:NPA_Logo.jpg@25c98a29.2b7041a9"></A><A HREF="http://www.npaconsult.co.uk/about-news.asp" STYLE="outline-width: 0; border-collapse: collapse; text-decoration: none; outline-style: none;
border-style: none; margin: 0; padding: 0;"><IMG ALT="Nicholas Pearson Associates, Latest News" BORDER="0" SRC="cid:Email_Footer_News.jpg@edf327cc.272f4df5"></A>
</TD>
</TR>
</TABLE>
<P STYLE="margin-top: 7.5px; margin-bottom: 7.5px; text-align: left; color: #000000;
font-size: 7pt; font-family: Verdana;">
<A HREF="http://www.npaconsult.co.uk/terms.asp" STYLE="text-decoration: none; color: #000000;">
Information and Registered Address</A>
</P>
<P STYLE="margin-top: 5px; margin-bottom: 10px; text-align: left; color: #666666;
font-size: 7pt; font-family: Verdana;">
This Electronic Transmission is intended only for the attention of the addressee.
It may contain privileged and confidential information. If you are not the person
for whom it is intended, you must not copy, distribute or take any action in reliance
on it. If you have received this electronic transmission in error please notify
us immediately by telephone, delete the transmission and destroy any hard copies.
</P>
<P STYLE="margin-top: 5px; margin-bottom: 10px; text-align: left; color: #666666;
font-size: 7pt; font-family: Verdana;">
Nicholas Pearson Associates has used all reasonable efforts to ensure that this
message and any attachments are free from viruses.</P>
<P STYLE="margin-top: 5px; margin-bottom: 10px; text-align: left; color: #666666;
font-size: 7pt; font-family: Verdana;">
Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225
445548, Fax: +44 (0) 01225 312387, Website: <A HREF="http://www.npaconsult.co.uk/">http://www.npaconsult.co.uk</A></P>
</BODY></HTML>