Too few parameters. Expected 1

[Emmanuel Ayivi]

I want to select data from a table called tblfeesdetails into another table with two criteria but it stops in line three(3) and highlighted yellow showing the error "Too few parameters. Expected 1"

strsqldetails = "Select * from tblfeesdetails where groupid = """ & mgroupid & """ AND Tdate = Date ; "
 
Set rstd = CurrentDb.OpenRecordset(strsqldetails)

[TheSmileyCoder]

Instead of the doubled up quotes try this:

"Select * from tblfeesdetails where groupid = '" & mgroupid & "' AND Tdate = Date"

Note that this is a SELECT query, and you will simply open a recordset of the results. There is nothing here to transfer any data into a new table.