Search results

  1. C

    Open variable number of queries

    What would the best way to open a series of queries, if you aren't sure how many of those queries there are? I have the following: DoCmd.Close acReport, "SCEFReport" DoCmd.OpenQuery "ClearTBLQuestions", acViewNormal, acEdit DoCmd.OpenQuery "Q1append", acViewNormal, acEdit...
  2. C

    Max UNION ALL in single query

    I'm having a small problem where Access returns a "Query too complex" error when I try to run a Union query of the form: SELECT CourseNumber, CourseTitle, [Date], TotalScore, "Two (2) zero visibility dives?" AS [Question], CountZeroVisibility AS [NegativeResponses] FROM qryScore UNION ALL...
  3. C

    Question Preventing overwrite of data by external 'save as'

    I have just finished blundering my way through creating a database for processing survey data into a report format. We receive these reports as paper copies, which are then scanned in using Remark Office OMR. This results in a table of data, which is intended to be appended to the existing table...
Back
Top Bottom