field of one record to a field of a different record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to compare the term date of a given record of a consumer with the effect date of a different record of same consumer. if term date is 1 less than effect date then the consumer is not needed. How can a field from one record be compared to a field of a different record? I have tried running exists and not ins for sub queries and am gettng no where. Thanks.
 
Seeker,

This is pretty vague, can you give us an example of what your data looks
like and what you are hoping the output would look like?

Dale

seeker53 said:
I need to compare the term date of a given record of a consumer with the
Click to expand...
effect date of a different record of same consumer. if term date is 1 less
than effect date then the consumer is not needed. How can a field from one
record be compared to a field of a different record? I have tried running
exists and not ins for sub queries and am gettng no where. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Compare records in same access table 0
Have both records from two queries/tables under one Query without related fields. 0
Query to duplicate a record with one field updated 0
Comparing two fields in two different records 6
Query for 1st field, if blank then query 2nd field but not both. 6
counting Null fields 3
Maximum Value in 2 fields of a record 1
showing records where one field is duplicated and another is not 2

Back
Top