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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. benredik

    SQL syntax required for finding "grouped" minimum

    Thank you, it was the 's and "s that caused me trouble!
  2. benredik

    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...
  3. benredik

    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.
  4. benredik

    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...

Part and Inventory Search

Back
Top