Sheet 1 is a flat table with 3 new records manually inserted, Reports bonded to Sheet 1 with order by LOT on load, do not position / sort the new inserted records. They are included in the report but are at the end of the report.
Sheet 1 is a flat table with 3 new records manually inserted, Reports bonded to Sheet 1 with order by LOT on load, do not position / sort the new inserted records. They are included in the report but are at the end of the report.
What do you mean by "sheet"? This is Access linked to Excel? Why is Excel involved?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.