Append Query

[waqas]

dear all,
i am using append query to insert record from first table to second table

query as below


INSERT INTO tblOFF ( ID, OFFdate, OFF )
SELECT EmpClocking.ID, Format(EmpClocking.CIN,"dd-mmm-yy") AS OFFDATE, EmpClocking.OFFTYPE
FROM EmpClocking
WHERE (((EmpClocking.OFFTYPE)="OFF"));
in empclocking one id number has more then one record
but this query insert only one record which is first record
later record it is not inserting what should i do?

[pbaldy]

And the other record(s) meet the criteria? Could it be hitting any key violations? That should append all that meet the criteria, presuming no key violations, so if you're saying it doesn't, can you post a sample db that fails to?

[waqas]

yes thanks.

it was key violation

now i am facing null or empty cells

SELECT EmpClocking.ID, EmpClocking.CIN, EmpClocking.cout, EmpClocking.SHIFTCODE
FROM EmpClocking
WHERE (((EmpClocking.OtherType)=IsNull([EmpClocking]![OtherType])));

i know there are empty cells in othertype column but nothing is appearing in query result

[pbaldy]

Try

WHERE [EmpClocking]![OtherType] Is Null

[waqas]

THANKS

its working fine.

[pbaldy]

Happy to help!