Need Help

  • Thread starter Thread starter rblivewire
  • Start date Start date
R

rblivewire

I need to create a query. I have 3 columns. "Match column", "Date
column", and "field 1" which counts from 1 to 1000. The numbers in the
"match column" are jumbled around. I need a query that looks through
the match column and matches the number it finds with the field 1
number and the returns the date that is next to the field 1 column.
What is the best function to use?
 
Join two instances of the table (a self-join). Try this:

SELECT T1.[Match Column], T2.[Date Column]
FRO YourTable As T1 INNER JOIN YourTable AS T2
ON T1.[Match Column] = T2.[Field 1];

Ken Sheridan
Stafford, England
 
Back
Top