Search results

  1. M

    Another query - retrieving records?

    Hi, I need to retrieve records from a query by date - the criteria is all records for the current month from last year or any year previous to last year ...i.e this month last year or before last year.. Does anybody know what the expression/criteria would be for this? Thanks to the help of...
  2. M

    Help retrieving records by date range..what's the expression?

    Hi all, I need help retrieving records... the records I need the query to retrieve are from the current month one year ago, or this month last year Can anybody help me with this? Thanks! Anna
  3. M

    2 parameters in one query

    Hello, I have a query containing two parameters, one is for a date range and the other for an identifier. it looks like this In the 'or' line of the date column: Is Null or Between [start date] and [end date] and in the 'criteria' line of the identifier column: [Enter Identifier]...
  4. M

    Form Macro - OLE error?

    Hi, I have several checkboxes on a form that represent different reports, I have a macro attached to a 'print preview' button that shows the report for the checkbox which is active, in the condition of the macro I have the following: [screen].[activeform].[chkboxname]= -1 then Action 'Open...
Back
Top Bottom