Invalid arguement error when I try to save query. 1

[cojiro]

Everytime I try to save the following query in Access I get an error message "invalid arguement".
Does anyone know what I need to change to get this to work?

SELECT 
dbo_traveltransaction.LASTNAME, 
dbo_traveltransaction.FIRSTNAME, 
dbo_traveltransaction.DEPARTMENT,
IIf(dbo_traveltransaction.ALLOCATIONLABEL Is Null,dbo_traveltransaction.DEPARTMENT,dbo_traveltransaction.ALLOCATIONLABEL) AS Allocation,
dbo_traveltransaction.CATEGORYSEGMENT1,
IIf(dbo_traveltransaction.SUBMISSIONNAME Is Null,"Unsubmitted",dbo_traveltransaction.SUBMISSIONNAME) AS SubmissionName, 
dbo_traveltransaction.TRANSACTIONDATE, 
dbo_traveltransaction.AMOUNT, 
dbo_traveltransaction.NONREIMBURSABLE, 
IIf(dbo_traveltransaction.DISTRIBUTEDATE is null,"UnPaid","Paid") AS TransactionStatus 
INTO [New Travel Transaction]
FROM dbo_traveltransaction;

 

[Golom]

Use
[blue][tt]
AS [SubmissionName]
[/tt][/blue]
You are attempting to define a field alias to be the same as an existing field name.

 

[cojiro]

Thanks Golom.