Search results

  1. C

    Query records match >20 display

    Hi Thanks I simply copied and pasted teh above into the SQL View and hit run: SELECT DSResult.STATUS, DSResult.TESTCODE, DSResult.BATCHNO, DSResult.TESTNO, DSResult.TESTDATE, DSResult.CODE FROM DSResult WHERE (SELECT Count(*) FROM DSResult as tmp WHERE Code=DSResult.code)>20 AND...
  2. C

    Query records match >20 display

    Thanks ever so much for your help. Ive replaced the sql xcode with yours and when I run the query it just hangs 'Running Query' but nothing happens. There are 35000 records :(
  3. C

    Query records match >20 display

    Hi There Im hoping someone can help :) I have a db which has a query. This query is rather simple where it filters fields based on criteria. Here is the SQL VIEW: SELECT DSResult.STATUS, DSResult.TESTCODE, DSResult.BATCHNO, DSResult.TESTNO, DSResult.TESTDATE, DSResult.CODE FROM DSResult...
  4. C

    Alter records in Access Table

    Hi Im new and this is my first thread :) Im hoping some of you kind people can help me? We have a database which has a table with 2 fields - here is an example of the data: Order File Path 240971 cclapps1\scanner\Works Orders 2008\Works Orders...
Back
Top Bottom