<div>
Try this:<br />
<br />
SELECT * FROM YourTable<br />
WHERE Country = &quot;GB&quot;<br />
OR [Country Event] = &quot;GB&quot;
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
I have a table that contains 2 fields that I need to be able to compare and return results<br />
Field 1 is Country<br />
Field 2 is Country event<br />
The fields contain country codes, for example GB, USA, GER and so on.<br />
What I want to do is for access to check this 2 fields, if either field contains GB then return the data<br />
So for example Field1 Contains GB Field2 Contains GER, the data should be returned. Like wise is Field1 Contains GER and Field2 Contains GB then data should be returned. If GB is present in both fields then data should also be returned.<br />
If Field1 &nbsp;Fields2 both do not contain GB data should not be returned so Example Field1 GER Field2 USA do not return data<br />
<br />
Hope that makes sense, I suspect it is simple but just cant get the query to pull all the data<br />
<br />
Thank<br />
Michael
</div>
</div>


Hi
I have a table that contains 2 fields that I need to be able to compare and return results
Field 1 is Country
Field 2 is Country event
The fields contain country codes, for example GB, USA, GER and so on.
What I want to do is for access to check this 2 fields, if either field contains GB then return the data
So for example Field1 Contains GB Field2 Contains GER, the data should be returned. Like wise is Field1 Contains GER and Field2 Contains GB then data should be returned. If GB is present in both fields then data should also be returned.
If Field1  Fields2 both do not contain GB data should not be returned so Example Field1 GER Field2 USA do not return data

Hope that makes sense, I suspect it is simple but just cant get the query to pull all the data

Thank
Michael

Try this:

SELECT * FROM YourTable
WHERE Country = &quot;GB&quot;
OR [Country Event] = &quot;GB&quot;

Access query Help

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.