Recent content by ChuiceBox

  1. C

    Union Query with seperate column?

    Hi, I have a union query which successfully returns the totals from other queries but I can't make it return the totals in separate headings. For example currently it returns like this: Heading: Total1 Total2 Total3 When what I need is: Heading1:--------Heading2:--------Heading3...
  2. C

    Best way to prompt user input?

    Hi Access Programmers! I am in a bit of a predicament. I have a form with a command button which runs a macro which generates a report and exports it as a pdf, this is based on a date range and some other critera. However, before this report is generated I would like to check a table for data...
  3. C

    Null values + INSERT INTO problem

    Hi, I'm have some VBA code which uses DAVG to calculate average of several columns in my table based on a column selected in a combo box, It then appends these averages to the same table using INSERT INTO. That all works UNTIL davg has a selection of null values and trys to pass a null to...
See more
Back
Top Bottom