This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 65%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
I'm using the following SQL to display records with today's (17th) date and past due date:
Problem is it also displays 2 records that dated on the 20th duplicate the 2 records.
Any ideas?
James
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Your SQL didn't survive the upload. Please try again.
We can not guess very well about those two records without actually seeing that SQL as well as the data in the query to see how the dates actually formatted (or not formatted).
Thank you.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Cross-posted, with answers, on AWF. https://www.access-programmers.co.uk/forums/threads/sql-issue.335610/#post-1993142