Link to home
Start Free TrialLog in
Avatar of PeterBaileyUk
PeterBaileyUk

asked on

parameter on append

I would like the query to ask for the year month. in my query at present it is wriiten in to the sql how do i add as a parameter?

INSERT INTO AbiBuilds ( abiCode, BuildYearMonth )
SELECT tClient.abiCode, "2012-09" AS Expr1
FROM tClient;

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Bhavesh Shah
Bhavesh Shah
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial