Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to Set up OCR character in Report Header based on Report Length
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...- jdbass
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Finding the second highest value - HOW?
You could also use the Select Top capability... SELECT TOP 2 tblScheduleMetrics.SqFtPerPallet FROM tblScheduleMetrics GROUP BY tblScheduleMetrics.SqFtPerPallet ORDER BY tblScheduleMetrics.SqFtPerPallet DESC;- jdbass
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Runtime Access Query Confirmation? Why?
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...- jdbass
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
