Append query to skip blank fileds???

[King_kamikaze]

Hi,

Could anyone please tell me what is wrong with the following SQL?

INSERT INTO TableB_Rejected ( Rejected, Reason )
SELECT TableB.Rejected, TableB.Reason
FROM TableA
WHERE (((TableB.Rejected)<>""));

I am tring to take all the fields with data in from one table and put them in another, i do not want it to copy accross the blank fields.

Any help would be greatly apreciated.

Many thanks
Tim

 

[namliam]

Does NULL mean anything to you ?

 

[King_kamikaze]

Worked a treat thanks, i am fairly new with databases but i am picking up loads of stuff as i go, that another thing to add to the memory bank.

Many thanks.
Tim

 

[chris davies]

Use the query wizard, select the fields you need to copy over, go into design view and set the query type as append, and select the table you want to add the data to. This works for me.
Chris