G
Guest
I've Inserted these fields from a FORM except the AgentID which is the
primary key for the table.
The AgentID equal the first letter of the firstname, middleInitial,and
lastname.
This is the SQL But it gave me hard time executing it it shows error missing
operator in the expression.please someone give an idea.
INSERT INTO Agents
(AgentID,FirstName, MiddleInitial, LastName, EmailAddress, Address, City,
State, ZipCode, WorkPhone)
VALUES
(AgentID:'#Left(Form.AgentFirstName,1)#' '#(Form.MiddleInitial)#'
'#Left(Form.AgentLastName,1)#',
'#Form.AgentFirstName#','#Form.MiddleInitial#', '#Form.AgentLastName#',
'#Form.EmailAddress#', '#Form.Address#', '#Form.City#',
'#Form.State#', '#Form.ZipCode#', '#Form.WorkPhone#')
primary key for the table.
The AgentID equal the first letter of the firstname, middleInitial,and
lastname.
This is the SQL But it gave me hard time executing it it shows error missing
operator in the expression.please someone give an idea.
INSERT INTO Agents
(AgentID,FirstName, MiddleInitial, LastName, EmailAddress, Address, City,
State, ZipCode, WorkPhone)
VALUES
(AgentID:'#Left(Form.AgentFirstName,1)#' '#(Form.MiddleInitial)#'
'#Left(Form.AgentLastName,1)#',
'#Form.AgentFirstName#','#Form.MiddleInitial#', '#Form.AgentLastName#',
'#Form.EmailAddress#', '#Form.Address#', '#Form.City#',
'#Form.State#', '#Form.ZipCode#', '#Form.WorkPhone#')