Query Group by "SQL string"

[kon]

Here is my sql string and the message is "No
value given for one or more required parameters"

"INSERT INTO masterdype ( activeyear, dypeid, hospitalid, degrees, served,
dutied ) SELECT qrmasterstatlinked.activeyear, qrmasterstatlinked.dypeid,
qrmasterstatlinked.hospitalid, qrmasterstatlinked.degrees,
qrmasterstatlinked.sumofserved, qrmasterstatlinked.sumofdutied FROM
qrmasterstatlinked"
the masterdype is a table where I want the group by and sum results to be
entered and the qrmasterstatlinked is the query which is a group by. Please
tellme where am I doing wrong;

 

[Tom Ellison]

Dear Kon:

I sounds like your qrmasterstatlinked is a query that requires parameters.
Otherwise, check the spelling of all the references in this query.

Tom Ellison