Hi,
I am trying to link some tables from different data sources together (see attached document) and I'm having a few problems. The 'Oris_Data' table is from an SQL database and the other files are from an Access Database.What I want to be able to do is say the 'Total_Invoice_Cost' has to be greater than or equal to the 'RVI_Amount_Min' and less than or equal to the 'RVI_Amount_Max' (also trying this with the 'Term' field) but I keep getting the message "Invalid Argument provided'.
Any help would be greatly appreciated.
I am using CRXI.
Thanks
I am trying to link some tables from different data sources together (see attached document) and I'm having a few problems. The 'Oris_Data' table is from an SQL database and the other files are from an Access Database.What I want to be able to do is say the 'Total_Invoice_Cost' has to be greater than or equal to the 'RVI_Amount_Min' and less than or equal to the 'RVI_Amount_Max' (also trying this with the 'Term' field) but I keep getting the message "Invalid Argument provided'.
Any help would be greatly appreciated.
I am using CRXI.
Thanks