<div>
You can do something like this to do what you are looking for..<br />
<br />

<pre><code id="code-20-40658559-1">select tb1.* from 
table1 tb1
where tb1.day=tb1.code and tb1.day&lt;&gt;tb1.hours;</code></pre>
<br />
Saurabh...
</div>


You can do something like this to do what you are looking for..



select tb1.* from 
table1 tb1
where tb1.day=tb1.code and tb1.day<>tb1.hours;


Saurabh...

<div>
Thanks for the prompt response, I need to clarify my question with an example:<br />
Day,Code,Hours<br />
1,5,8<br />
1,4,6<br />
1,5,7<br />
1,4,6<br />
<br />
Query returns these records:<br />
1,5,8<br />
1,5,7<br />
<br />
As these two records have identical values for both Day and Code, but different value for hours.
</div>


Thanks for the prompt response, I need to clarify my question with an example:
Day,Code,Hours
1,5,8
1,4,6
1,5,7
1,4,6

Query returns these records:
1,5,8
1,5,7

As these two records have identical values for both Day and Code, but different value for hours.

<div>
<div class="content wysiwyg-content">
I have a table which contains the following fields: Day, Code and hours.<br />
I need a query which will return all records where day and code are equal, but hours is different.
</div>
</div>


I have a table which contains the following fields: Day, Code and hours.
I need a query which will return all records where day and code are equal, but hours is different.

Access query

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.