Hi Guys someone made an Access database before i arrived and has now left, it was working before but now i get "Data mismatch type" and i have NO idea why it has stopped working. Could someone please help me the SQL is below.
SELECT Val([RAW_AR_Data_Table]![Account]) AS Account, IIf([RAW_AR_Data_Table]![Assignment]="",Val([RAW_AR_Data_Table]![Document Number]),IIf(Len([RAW_AR_Data_Table]![Assignment])<10,Val(0),Val([RAW_AR_Data_Table]![Document Number]))) AS [Invoice Document Number], RAW_AR_Data_Table.[Document currency], RAW_AR_Data_Table.[Amount in doc curr], RAW_AR_Data_Table.[Local Currency], RAW_AR_Data_Table.[Amount in local currency], RAW_AR_Data_Table.Text, RAW_AR_Data_Table.[Net due date], RAW_AR_Data_Table.[Document Date], IIf([RAW_AR_Data_Table]![Net due date]>Now(),0,DateValue(Now())-([RAW_AR_Data_Table]![Net due date])) AS [Age Uncleared] INTO RAW_AR_Data_Reformat_Table
FROM RAW_AR_Data_Table
WHERE (((IIf([RAW_AR_Data_Table]![Assignment]="",Val([RAW_AR_Data_Table]![Document Number]),IIf(Len([RAW_AR_Data_Table]![Assignment])<10,Val(0),Val([RAW_AR_Data_Table]![Document Number]))))>0) AND ((RAW_AR_Data_Table.[Document Type]) Like "RV"));
SELECT Val([RAW_AR_Data_Table]![Account]) AS Account, IIf([RAW_AR_Data_Table]![Assignment]="",Val([RAW_AR_Data_Table]![Document Number]),IIf(Len([RAW_AR_Data_Table]![Assignment])<10,Val(0),Val([RAW_AR_Data_Table]![Document Number]))) AS [Invoice Document Number], RAW_AR_Data_Table.[Document currency], RAW_AR_Data_Table.[Amount in doc curr], RAW_AR_Data_Table.[Local Currency], RAW_AR_Data_Table.[Amount in local currency], RAW_AR_Data_Table.Text, RAW_AR_Data_Table.[Net due date], RAW_AR_Data_Table.[Document Date], IIf([RAW_AR_Data_Table]![Net due date]>Now(),0,DateValue(Now())-([RAW_AR_Data_Table]![Net due date])) AS [Age Uncleared] INTO RAW_AR_Data_Reformat_Table
FROM RAW_AR_Data_Table
WHERE (((IIf([RAW_AR_Data_Table]![Assignment]="",Val([RAW_AR_Data_Table]![Document Number]),IIf(Len([RAW_AR_Data_Table]![Assignment])<10,Val(0),Val([RAW_AR_Data_Table]![Document Number]))))>0) AND ((RAW_AR_Data_Table.[Document Type]) Like "RV"));