Matching Unique Fields

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

Guest

I have two tables, both have a unique field (AFS). How do I code a textbox
that shows only those AFS's that match in both tables?
 
I have two tables, both have a unique field (AFS). How do I code a textbox
that shows only those AFS's that match in both tables?
Click to expand...

A *textbox*? What if there were 33812 records which matched? What do
you want to see on the screen? It would need to be a rather large
textbox!

You can create a Query joining the two tables by AFS, and select
whatever fields you would like to see from this Query; you can then
base a Form (for onscreen viewing) or Report (for printing) on the
query.

John W. Vinson[MVP]
 
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

Unique values in two fields in query 1
Retrieve Column Header for Specific Data in a Row 3
Error on text wrap pivot table 1
dcount() query 1
Displaying records that have one of two fields equal to Master Field 3
Multiple Offset/Match formula returns "#N/A" 2
Match multiple field records to any sub records. (complex....) 1
VALUE appearing (referencing blank cell) 3

Back
Top