Search results

  1. H

    Make Criteria non-mandatory

    I have a set of criteria that require user input when generating the query-based report. 3 for entering the project number a user would like to search [Enter first collator] Or [Enter second collator] Or [Enter third collator] Only the first collator needs to be entered to have a successful...
  2. H

    Query-based report returning misinformation

    The "header" in my report pulls informaitn from a query to sort expense information based on Responsibility Centre and project code. When the report is run the first 2 projects have the same number which then puts the remainder of the projects one-step out and they don't macth up woth the...
  3. H

    Different users write to different tables?

    I have a need to allow multiple users to have access to the same form, but restrict the information they retrieve from the database via reports. For example, my "transaction" table records all the information regarding the different projects I track expenses for. There are 2 managers who, based...
  4. H

    Query between dates

    I have mastered forms and simple reports, buut now a querey seems to have me bogged down. Following is my "Transaction" table: TransactionNumber : AutoNumber AllotmentCode: Text (Look-up from separate table) Business Line: text (look-up form separate table) Resp Centre: Text (look-up form...
Back
Top Bottom