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 Chriss Miller 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: *

  • Users: HoganGroup
  • Content: Threads
  • Order by date
  1. HoganGroup

    Query which groups months between startdate and enddate

    Hi fellows: I am at a complete lost as to how to construct a query or report to answer this question. Any help is greatly appreciated. The question I need to answer is this: Identify the SchID and month for each SchID/Month combo for which there is not at least one associated AttendanceDate...
  2. HoganGroup

    With Export File Wizard, "Two Few Parameters. Expected 2."

    I need to create an export file for the following brutal query to upload into a state database (go figure it's a government report!) All was good in my world until I tried to export. Manually or TransferText, didn't matter, it just hated me. The above error stopped me cold in my tracks...
  3. HoganGroup

    Create Query to evaluate Max Date recognizing Null as High Value

    Hi Experts and Fellow Duffers: I am trying to create a query which will identify the most recent EndDate in tblSchedules associated with tblKids.KidID where a Null value (indicating a current schedule) is the most recent. Max(EndDate) doesn't recognize Null as the highest value. Last(EndDate)...

Part and Inventory Search

Back
Top