Help

[JonyBravo]

Hi there!
I'm using the following query code in my database:

INSERT INTO tblPlanner ( RACF, [Date], [Day Capacity] )
SELECT tblStaff.RACF, [forms]![tblLeader].[txtday1] AS Expr1, tblStaff.[Daily Capability]
FROM tblStaff
WHERE (((tblStaff.TeamName) Like [forms]![tblLeader].[txtTeamName]))
WITH OWNERACCESS OPTION;

Can someone tell me I to write the same in VB SQL?

Thanks

 

[namliam]

INSERT INTO tblPlanner ( RACF, [Date], [Day Capacity] )
SELECT tblStaff.RACF, [forms]![tblLeader].[txtday1] AS Expr1, tblStaff.[Daily Capability]
FROM tblStaff
WHERE (((tblStaff.TeamName) Like [forms]![tblLeader].[txtTeamName]))
WITH OWNERACCESS OPTION;

Done ?? Tho you should look into NAMING CONVENTIONS... You shouldnt use spaces in column names AND you shouldnt use Date as a column name...