Search results

  1. C

    Pivot Chart COnditional Formatting

    I have a pivot chart that is formatted to display category on the vertical access and series values on the horizontal axis. The categoty (vertical axis) is employe name. The series (horizontal axis) is the timme they have been working. The categories (employees) are sorted according to the...
  2. C

    Select the most recent entry from multiple tables

    I have a query that selects records from four different tables. The mother table contains personal information and three daughter tables are related to the first via the mother table's primary keywhich can have no entry per person, one entry per person or multiple entries per person. A query...
  3. C

    Select multiple options from multiple parameters

    I have a database with a lot of data regarding treatment of cancer patients. There is a separate table containing patients details. There are three different tables for surgery, radiotherapy and chemotherapy. They all all joined to the patient data table by LEFT joins so that a patient who...
  4. C

    Using a form to set query parameters

    I am trying to create a form (in accrss 2003) where users can select information between 2 dates and then specify other criteria to narrow the search. The form has 2 combo boxes with calendars that sets start and end dates and a command button runs a query refering to them as Between...
Back
Top Bottom