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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Table recordsets input/output mismatch
Traingamer, Okay, you are saying within the code I can open a record set that uses the ORDER BY clause to create a sorted query on the table? From the Access help, it appears the ORDER BY is a SQL command...which I am not at all familiar with. But if I follow your idea, would my added code look...- floorwax
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Table recordsets input/output mismatch
Hello Traingamer, I would like to do a simple Group By query; however, I am doing much more than a simple average of pressure inside my do loop. In detail, I am checking for only positive pressures to be a part of the average. I am also calculating the maximum average hourly pressure. On top of...- floorwax
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Table recordsets input/output mismatch
Hello, Hopefully this is something simple for the programming professional since I am only a casual user. I have a table of pressure data with a date/time stamp as the primary key. There are over 300K recordsets (data for each minute). My objective is to read in one day of data (up to 1440...- floorwax
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
