<div>
how do I construct the query so that the dates are in the correct form when running?
</div>


how do I construct the query so that the dates are in the correct form when running?

<div>
as posted above, use the format function as needed...
</div>


as posted above, use the format function as needed...

<div>
I mean where do I put the functions in the access query ? i.e. Field name, table,criteria, etc..<br />
tks
</div>


I mean where do I put the functions in the access query ? i.e. Field name, table,criteria, etc..
tks

<div>
are you working in a SQL Query Window, or pure sql?<br />
the table names remain as they are, instead of the field name, you put the expression having the <i>function(fieldname)</i> instead of just <i>fieldname</i>
</div>


are you working in a SQL Query Window, or pure sql?
the table names remain as they are, instead of the field name, you put the expression having the function(fieldname) instead of just fieldname

<div>
<div class="content wysiwyg-content">
I have 2 linked .dbf tables that I want to check for unmatched entries on 2 fields. Field#1 is a text field in both tables. field#2 is a text field in table#1 which contains a date in the format yyyymmdd. field#2 is a date field in table#2 in the format mm/dd/yyyy.<br />
<br />
I need a query that will detect an unmatched entry based on the 2 fields. Don't know how to specify/convert field#2 in table#1 so that I don't get a &quot;type mismatch&quot; error on the 2 date fields.<br />
<br />
Source tables cannot be changed.<br />
tks
</div>
</div>


I have 2 linked .dbf tables that I want to check for unmatched entries on 2 fields. Field#1 is a text field in both tables. field#2 is a text field in table#1 which contains a date in the format yyyymmdd. field#2 is a date field in table#2 in the format mm/dd/yyyy.

I need a query that will detect an unmatched entry based on the 2 fields. Don't know how to specify/convert field#2 in table#1 so that I don't get a "type mismatch" error on the 2 date fields.

Source tables cannot be changed.
tks

ms access query - find unmatched

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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.