Re: an easy one (it was easy)

On Fri, 04 Jul 2008 04:04:08 GMT, "Jim" <jimt@[EMAIL PROTECTED]
> wrote:

>just in case anyone else had a similar question, I figured this out by 
>mimicking the code in another database that uses an append sql statement
>
>Mine goes as such:
>dim strsql as string
>strsql = "INSERT INTO tblPayRollSub ( Employee, PayrollID )" _
>& "SELECT Employees.EmpName, (forms!frmpayrollheader!prheaderid) AS
PR_ID" _
>& "FROM Employees" _
>& "WHERE (((Employees.Status) = strstat) And ((Employees.Type) =
strtype))" 
>_
>& "ORDER BY Employees.EmpName;"
>
>
>Cheers,
>

I predict you're going to have problems with that. Just exactly what
are strstat and strtype?