Search results

  1. C

    2 seperate parameters for one query

    The easiest way to get your input boxes is to open your query in design view. In the "Criteria" field under extension number type "[Enter first extension:]" without the quotes, In the "or" field under extension number type "[Enter second extension:]" without the quotes. This will prompt you for...
  2. C

    Requery Help !!!

    Are you using a button to update the record or just entering it straight into the table? If you are entering it straight, you may want to add a button anyway in order to execute a refresh of the forms. To do this, simply add a button to the form and select refresh form in the button wizard.
  3. C

    Count 2 possibilities in same query/form

    Pat, you are the man. I have been looking all over the net for weeks and could not put my finger on it. Thank You!
  4. C

    Conditional query?

    i hard coded the query to be >1 AND <20 with no errors. Is it possible that your [results]![rl] or [results]![mdl] are returning more than one value?
  5. C

    Find Duplicates, then tag them?

    I am not clear as to your problem. It sounds like you are trying to update the query results instead of updating a field in your table.
  6. C

    Count 2 possibilities in same query/form

    I am trying to make a query or form that will display a count for the total number of tickets "open" and at the same time display the number of tickets "closed". I can do each seperately in queries using the following SQL: SELECT Sheet1.[Client ID] AS School, Count(Sheet1.[Assigned To]) AS...
Back
Top Bottom