Is there a way to have a query return the inverse of what a SELECT TOP n (or n%) would return? For example if there are 100 records and I want those records, in alpha order, that are not the first 10 records. SELECT NOT TOP 10 obviously not correct SQL but that's the kind of thing I want to do. Is this possible?
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…