Hi All,
I'm having a rather interesting issue with Access 2003 runtime and an append query.
I have switched off warnings to see what was happening and when they are running the append query it says it will append 0 records. :confused:
Although when running it on my machine (Full version) it says 1 record, using the same criteria.
Is there anything on the runtime that might stop an append query? I'm pretty sure it's worked in the past, but it's now effecting a few people and it's a little strange.
Thanks for any assistance.
Matt

It's based on the data and the conditions you are applying, could you please forward the table with query?

Thanks for your reply.
It's based on details entered on a form.

INSERT INTO [Introducer-Emp] ( BusId, Active, StartDate, EndDate, [Mail Ind], IntName, PartyId, PartyType )
SELECT [Forms]![frmIntroducers-Parties]![BusId] AS Expr1, [forms]![frmInt-Emp-Add]![Active] AS Expr5, [forms]![frmInt-Emp-Add]![StartDate] AS Expr6, [forms]![frmInt-Emp-Add]![EndDate] AS Expr7, [forms]![frmInt-Emp-Add]![MailInd] AS Expr8, [forms]![frmInt-Emp-Add]![IntName] AS Expr9, Parties.[Party Id], [forms]![frmInt-Emp-Add]![PartyType] AS Expr10
FROM Parties
WHERE (((Parties.[Party Id])=[Forms]![frmInt-Emp-Add]![frmInt-Emp-Add-Detail]![Party Id]));


Thanks.