Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking Tables

Status
Not open for further replies.

Smithsc

MIS
Apr 20, 2007
143
GB
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 can't access the linked file. Can you re link it?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top