I have a report that will print for multiple customers. If the customers have too many records, their report will go to 2 or more pages.
Example:
Overall report is 4 pages.
Customer 1 - 1 page
Customer 2 - 1 page
Customer 3 - 2 pages
The 4 page report gets sent to an OCR device for auto...
You could also use the Select Top capability...
SELECT TOP 2 tblScheduleMetrics.SqFtPerPallet
FROM tblScheduleMetrics
GROUP BY tblScheduleMetrics.SqFtPerPallet
ORDER BY tblScheduleMetrics.SqFtPerPallet DESC;
I have an Access backend on the server and am attempting to distribute the front-end using Access Runtime. The problem is users with Runtime get all of the query confirmation messages...even though the database that they are using has them all turned off in the Options menu.
I know I can do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.