Search results

  1. L

    Query Works - Query with Criteria returns error

    I can run my query and retreive the results, however, when I try to add a criteria (col value >0.04) I get a Division By Zero message. I also get this when I try to sort on the same column. Any ideas please? Thanks in advance
  2. L

    Question Select Query or Make Table query

    I am starting to build a database and have to decide whether to use select queries or make table queries. Can anyone advise me on when it is best to use either type of query please? Are there guidelines on which is best in different circumstances?
  3. L

    Append New Values only

    HI, I currently get sent rows and rows of data, but am only ever interested in the last row of data for an event that I receive. I want to create a table that only shows me the last rows for these events, so i created a make table query that retreives the 'LAST' values. The problem with this...
Back
Top Bottom