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!
-
SQL syntax required for finding "grouped" minimum
Thank you, it was the 's and "s that caused me trouble!- benredik
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
SQL syntax required for finding "grouped" minimum
I need help with the syntax for the calculated field " Group Min". It should have the lowest value for all IDs within a type. So in this case the lowest score for any records for Type CAR is one. Type ID SCORE Group Min CAR AAA 1 1 CAR ABC 2 1 CAR BCA 3 1 BOAT AAC 2 2 BOAT CCA 3 2 PLANE CAC 3 1...- benredik
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Export query to Excel in "custom" folder
Thank you for the help VicRauch! It worked perfectly (except I had to change the acSpreadsheetTypeExcel9 to acSpreadsheetTypeExcel97 as I have Access 97). Thanks again.- benredik
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Export query to Excel in "custom" folder
Hello, I have a query that I would like to export as a Excel file. One of the fields in the query is a "keydate" (mmyy), with a value that is the same for all records in the query, that I would like to export to a folder called the keydate (mmyy). example: C:\database\opex\0406\DirectOpex.xls...- benredik
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
