Search results

  1. T

    What's your (non-work) project and how's it going?

    This is mine, 5+ years into it and the wheels will be going on soon! two ways of looking at the same blog. www.facebook.com/1926Sunbeam www.vintagesunbeams.blogspot.com
  2. T

    Removing outliers

    I have just spent an hour developing this, it does what I need, but can it be improved upon? Basically I have a set of manual readings (valval) for a given item (keykey) We sometimes get some mad readings, but if the readings are a sensible distance apart (say 10) they can be trusted I...
  3. T

    Programming with nested queries

    I need to bring some order to a query chaos! Issues: Multiple programs and databases (.accdb) with many identical tables and identical queries. Many queries that would be identical except for "CustomerID", "Customer", "Customer ID" field name type issues Many queries that do the same things...
  4. T

    Going mad :)

    The following code should sum a field depending on the date. The field IncidentYear is created and set to Last, This or "-" depending on the date. I should get three rows, one for each of the three values.. I get..... you tried to execute a query that does not include the specified expression...
Top Bottom