P
PayeDoc
Hello All
I'm getting a "Too few parameters" error - sometimes - on the following:
Set rstS = CurrentDb.OpenRecordset("select * from [qry bulletin
recipients]")
The odd thing is that, when [qry bulletin recipients] is:
SELECT practices.email, practices.[prac mgr calling name], practices.[prac
name], practices.[20056 EOY]
FROM practices
WHERE (((practices.email)="(e-mail address removed)"));
.... there's no error, but when I amend the query to:
SELECT practices.email, practices.[prac mgr calling name], practices.[prac
name], practices.[20056 EOY]
FROM practices INNER JOIN [qry eoy stages] ON practices.[prac name] = [qry
eoy stages].[prac name]
WHERE (((practices.[20056 EOY])="1"));
.... I get the error. Nothing else is changed.
How can this be?
Hope someone can enlighten me.
Many thanks
Les
I'm getting a "Too few parameters" error - sometimes - on the following:
Set rstS = CurrentDb.OpenRecordset("select * from [qry bulletin
recipients]")
The odd thing is that, when [qry bulletin recipients] is:
SELECT practices.email, practices.[prac mgr calling name], practices.[prac
name], practices.[20056 EOY]
FROM practices
WHERE (((practices.email)="(e-mail address removed)"));
.... there's no error, but when I amend the query to:
SELECT practices.email, practices.[prac mgr calling name], practices.[prac
name], practices.[20056 EOY]
FROM practices INNER JOIN [qry eoy stages] ON practices.[prac name] = [qry
eoy stages].[prac name]
WHERE (((practices.[20056 EOY])="1"));
.... I get the error. Nothing else is changed.
How can this be?
Hope someone can enlighten me.
Many thanks
Les