Search results

  1. S

    problem with large database & pivot tables

    Hi there, I've developed over the past 3-4 years a database holding data relating to workload figures for my place of work. It has grown to a large size (eg. one table holds 1-2 million records). I've been trying to run a particular pivot table based on the sql query below: SELECT Tests.Test...
  2. S

    help please

    I've created a database containing workload statistic data in a table called [sets]. I populate this table each month from an external source. Each month I run a few queries on the table to output the previous month workload data - example output shown below: Data for month: Feb Set nameNumber...
  3. S

    populating field with query result

    I have got 2 tables: TAT table with fields: ID, SPB, SET, DAYSIN, HRSIN SETS table with fields: ID, SPB, SET, DAYSIN, HRSIN, plus a few other fields. Is it possible to do the following: If (SPB.TAT = SPB.SETS) AND (SET.TAT = SET.SETS) then store (DAYSIN.TAT in DAYSIN.SETS) AND (HRSIN.TAT in...
  4. S

    query a query

    I've got a table structure a shown below: Table1: ID Date Location Count Say I wanted to run a query outputing the Count for each location with a date range: SELECT Table1.Location, Count(Table1.Count) AS CountOfCount FROM Table1 WHERE (((Table1.Date) Between #1/1/2001# And #2/1/2001#)) GROUP...
  5. S

    excluding a field which exists in another table

    Hi All, Say you've got 2 tables and you want to extract data from table 1 but exclude all records from table 1 which have a field value existing in table 2? Table 1 fields: Test_Code Test_Desc Table 2 fields: Test_Code Therefore, I would like to query out from Table 1 all Test_Code values...
  6. S

    please help with this

    I have a table called 'sets' with 3 fields - spb, pat and set. An example of the table is shown below: spb pat set 1 123 ue 1 123 lft 2 123 ue 3 123 ue 4 1234 ue 4 1234 lft 5 123 ue 6 1234 lft For each 'set' I would like to output the total number of requests (a request is defined as having a...
  7. S

    help with a query

    I have a table called 'sets' with 3 fields - spb, pat and set. An example of the table is shown below: spb pat set 1 123 ue 1 123 lft 2 123 ue 3 123 ue 4 1234 ue 4 1234 lft 5 123 ue 6 1234 lft For each 'set' I would like to output the total number of requests (a request is defined as...
Back
Top Bottom