Matching Query for One Table

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

Guest

I have a table with two dates that could or could not match. What I am
trying to do is write a query that will pull those that match. Example an
individuals Exparation Term of Service field and Release Date. I want to
pull only those that match.

Thanks for all your help.
 
In your criteria for one field put the other one; e.g. underneath [Expiration
Term of Service] put as the criteria [Release Date]
 
Thanks, works great, maybe you can help me with this one, now a need to
write a query for the same fields and pull those that do not match.

K Dales said:
In your criteria for one field put the other one; e.g. underneath [Expiration
Term of Service] put as the criteria [Release Date]
--
- K Dales


SFCA said:
I have a table with two dates that could or could not match. What I am
trying to do is write a query that will pull those that match. Example an
individuals Exparation Term of Service field and Release Date. I want to
pull only those that match.

Thanks for all your help.
Click to expand...
Click to expand...
 
Back
Top