Problem with Append query with Exists function (1 Viewer)

[thechazm]

I have an issue where my Exists function in my Append query keeps giving me this error message "AggregateType is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not to long."

Here is the exists line.

Test: Exists (Select * from [SDSK Leave Taken] as e WHERE 
[Tmp CL].[IBB Date] = [e].[IBB Date] AND 
[Tmp CL].[Charge Date] = [e].[Charge Date] AND 
[Shops].[ID] = [e].[Home Shop ID] AND 
[Shops_1].[ID] = [e].[Borrow Shop ID] AND 
[tmpReference Personnel].[ID] = [e].[Badge ID] AND 
[SDSK Charge Types].[ID] = [e].[Charge Type ID] AND 
[Tmp CL].[Work Hour] = [e].[Charged Time])

If anyone can please help me out I would really appreciate it.

Almost forgot the reason I am using the exists function is to make sure the exact record does not exists and if it does not then insert it otherwise skip it because I have the criteria for the field set to false.

Thanks

 

[thechazm]

Please disregard I figured out it was just an access glitch and I had to delete the column and paste in my code again... figures

But here is another problem I am having with it. If a value in a column is null and I have it in my exists line it wants to add the whole record anyway. Is there anyway to mitigate this issue?