problem in Inserting a single row from one table to another

[tondarb]

I am having a table named table1 in which I am having details of customers. I want to insert a particular customer details to another table2( which is same as the table1)
I know in Sql we can use Insert.....

Insert into table2 select * from table1 where cusno='A001'

but in access it is not working. I am able to insert all rows but in this case I want to insert a single row using condition. can anyone is there to help me

thanks in advance

 

[KenReay]

Hi

You should be able to do as you say (ie use INSERT INTO ..etc), could you expand on 'not working' what actually happens, do you get an error message?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[tondarb]

thanks for the response.

Yes I know it must work but It is updating 0 rows.

It is giving the message "You are about to append 0 rows"

 

[KenReay]

Hi

What does "SELECT * FROM table1 where cusno='A001'" return ?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[tondarb]

It must return the details of that particular customer from table1 to table2
thanks for the response

 

[KenReay]

Hi

NO do not tell me what it MUST return, tell me what it DOES return, if your Insert statement said inserting 0 rows, then I suspect you will find the SELECT statement will return no rows, suggesting you have the SELECt statement wrong in some way

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[tondarb]

Yes you are correct here the select statement is returning 0 rows.
but I tried the same in SQl ,insert statement is working there. It is inserting the contents of table1 to table2. So I think the statement is correct but some minor mistake I have done.

I don't know much about access .
any way thanks for your suggestion.
regards