sql - MS Access - Query bringing in "new record" row -


i have query populating form , form allow data set edited. issue having query pulling last row used add new record. results in having row looks shows fields blank, leaves 1 field "null".

i played around query , able find workaround selecting "distinct" records, problem when select distinct, cannot edit data set. there other way around this?

i can upload example of database if needed. thanks!

edit: picture show issue: https://imgbomb.com/i/?ro1sp


Comments

Popular posts from this blog

java - Andrioid studio start fail: Fatal error initializing 'null' -

android - Gradle sync Error:Configuration with name 'default' not found -

StringGrid issue in Delphi XE8 firemonkey mobile app -