Recent content by chrisuff

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...

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...

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...

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...

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

For anyone reading this, I have just found the answer: add & "*" onto the end and it runs perfectly! eg [Forms]![Form2]![Combo0] & "*"

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...