Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    3

    Query Criteria


    I'm looking for a way to filter a current query to show only the records in which 2 fields from 1 row equal the value of a field in the previous row.

  2. #2
    llkhoutx is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Cycle trough the rows using DAO or ADO, row by row, comparing the appropriate fields' current row value to the previous row, appending the "ood" current row in a temporary table.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  2. Query Criteria
    By jena in forum Access
    Replies: 1
    Last Post: 08-03-2008, 04:08 AM
  3. Query Criteria
    By jena in forum Queries
    Replies: 1
    Last Post: 04-29-2008, 11:00 AM
  4. Need help with tables and query criteria
    By DevintheDude in forum Access
    Replies: 0
    Last Post: 09-12-2007, 08:41 AM
  5. Functions in Query Criteria
    By hraup in forum Queries
    Replies: 1
    Last Post: 10-06-2006, 06:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums