Search results

  1. H

    Query multiplication of null fields

    Hi I have a query resulting from several other querys. There is a potential problem in that I am multipling 3 query fields together. If there is data in each field then the query produces the desired result. If however one of the fields is blank/null the calculation of the other 2 fields does...
  2. H

    Automating email for 200+ graphs

    Hi I have a monthly job to send out 200 + graphs to our internal cutomers. The graphs are produced by me running a query that uses 3 variables - an id, a start date and an end date. I copy and paste the graph to an excel spreadsheet and send to the relevant customer. As you can imagine - its a...
  3. H

    Supressing a query

    Hi I have a query that uses 2 variables from a form. All the query is doing is checking whether the 2 variables exist in a table. 99% of the time there will not be a match. Does anybody know how you supress the query from being displayed when no results are found? Thanks Andrew
  4. H

    The Transfer of Graphs

    Hi I have created graphs via the chart wizard when creating a new form within a database application. I have many graphs that are created via the user inputing various dates and codes. I would like to create a monthly report for my dept and instead of tediously copying and pasting 15 graphs...
  5. H

    The transfer of forms to an excel file

    Hi Can anyone tell me if it ispossible to export a form from Access to a file in excel?
Back
Top Bottom