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...
 
You must log in or register to reply here.

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

Losing information when running a query 4
How to Identify Records with Overlapping Dates 2
Criteria for a Select Query 6
quick query question 3
two tables with matching fields 2
table 2
Have both records from two queries/tables under one Query without related fields. 0
Adding data in a 2nd query 5

Back
Top