I get the folloeing error, [Micr 1

[adsfx]

I get the folloeing error,

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

from sql,

SELECT [tbl_equiptypeperiph].[equiptypename], [tbl_periph].[periphID], [tbl_periph].[peserno], [tbl_periph].[petypeID], [tbl_periph].[equipID], [tbl_periph].[pemakeID], [tbl_periph].[pemodel], [tbl_periph].[peinst], [tbl_periph].[pecost], [tbl_periph].[pewarr], [tbl_periph].[penotes], [tbl_periph].[pesuppID]
FROM tbl_equiptypeperiph INNER JOIN tbl_periph
ON tbl_equiptypeperiph.equiptypeID = tbl_periph.petype ORDER BY [tbl_periph].[periphID] asc

ne ideas? cheers MG

 

[JJ26]

Are you sure when u join those 2 tables , you connect them with

tbl_equiptypeperiph.equiptypeID = tbl_periph.petype

.
you type tbl_periph.petype either than tbl_periph.petypeID
Check the field name.

 

[adsfx]

thanx alot jj26...heres a * - this prob wont help ne1 else but you sure helped me (will concentrate more in future!)