Search results

  1. O

    Query to show telephone allowances

    I'm analysing phone calls and costs for my employer. I have a table of around 8 million call records giving amongst other things - DistanceBand (eg Local, National, International) - Time Band (eg Daytime, Evening, Weekend) - Duration of call in seconds - Cost of call As you would expect, we pay...
  2. O

    Linking Query Criteria to Form Checkbox

    I'm sure there's an easy answer to this but its stumping me right now; I have a checkbox on a user input form. If the user ticks the checkbox, I want the query to return all records. If the box is unchecked, I want the query exclude certain records. I have used : Like...
  3. O

    Creating graph from Query

    I have a database of timesheet bookings. The relevant fields are WeekNumber, HoursQuantity and Category (Direct or Indirect). I am trying to create a graph from a query showing Week Number along the x axis and summary bars of Category on the chart then Hours on the y axis. This works fine when I...
  4. O

    Qury linked to Form with empty value

    Hi, I have created a query linked to combo boxes on a user input form with [forms]![inputform]![comboxx] as my criteria. This works fine until one of the combo boxes referred to is empty. In this case, I want to return all records, but the query returns no records at all. I have tried using...
Back
Top Bottom