Simple Select Query - help

  • Thread starter Thread starter rj
  • Start date Start date
R

rj

Hi,

I'm doing a select query that looks at two seperate
tables. The first table it looks at contains the list of
manufacturers i want to pull from the second table.

SELECT *
FROM Sheet1
WHERE (((Sheet1.line)=[lines]![line]));

I'm obviously not doing something right because it prompts
me for a parameter value.

Any help is appreciated,

Thanks
 
Hi,


SELECT sheet1.*
FROM sheet1 INNER JOIN lines
ON sheet1.line = lines.line



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top