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

    As always happens, I figure out how to do it about an hour after posting on this site.. Create queries for all 3 daughter tables. First Query is to SELECT DISTINCT the reference to the mother table's primary key. Second query joins the first query to the originating table and counts the number...
  3. 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...
  4. 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...
  5. C

    Return all results with parameters left blank

    I'm working on the same problem - Simon, where should the wild card go in the query design grid? Currently I have: Between [Forms]![Form1]![StartDate] And [Forms]![Form1]![EndDate] in the criteria window. Many thanks, Chris
  6. C

    Using a form to set query parameters

    For anyone reading this, I have just found the answer: add & "*" onto the end and it runs perfectly! eg [Forms]![Form2]![Combo0] & "*"
  7. 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