Search results

  1. C

    Showing all records and updateable

    I have three tables, one for employee names, one for test methods, and one showing which employees have been trained on which test method. I would like a query to show all employees and all test methods (even where there has been no entry). The only way I've found to do this is to create one...
  2. C

    Show all records in parameter query

    I have two related tables, tmain and a look up table for AccidentCauses. I can show all records for all accident causes (including those with no accidents) with the following SQL:- SELECT tAccidentCauses.AccidentCause, Count(tMain.IncidentID) AS CountOfIncidentID FROM tAccidentCauses LEFT JOIN...
  3. C

    Query to work out times

    Just wondered if this was possible or whether I need to adjust the set-up of my tables. I'm trying to work out the time taken for a chemical reaction to finish. I have a main table (tReactors) linked one-to-many by BatchID to a samples table (tSamples). The main table stores details of the...
  4. C

    "Correct" way of using a lookup table

    Just looking for some advice on the 'best' way of using a lookup table. Is the accepted way to have an autonumber ID and store the numerical value in the main table, thus saving space, or just to have the unique entries in the lookup table and use the text entries directly? Using the former I...
  5. C

    Report based on specific record(s)

    Apologies if this is a dumb question, I'm on my first database and I'm having problems with setting up my report. I've created my forms etc and I've placed a command button on one of the forms to show a formatted report. Is there a way to only show an 'individual' report for the currently...
Back
Top Bottom