double check your data types from your selection criteria. They need to match.
You say your SQL Server is being configured. Has this data been pulled down from SQL server to Access as a temporary solution for a database? If so and if for any reason some of your data is null, the word "NULL" may have been imported into Access. This if it was originally a numeric field, it isn't anymore. At 10:06 AM 12/11/01 -0500, you wrote: >I am getting a type mismatch error with this query. I am currently using >Access while waiting for SQL Server connection to be configured.I cant see >what ius causing the error? > > ><cfquery name="GetFunds" datasource="infotrac_test"> > select tbl_accounts.account_id, tbl_accounts.account, > tbl_fundsrc.fund_id, >tbl_fundsrc.type_fund, tbl_codes.code_id, tbl_codes.code > from tbl_accounts, tbl_fundsrc, tbl_codes > where tbl_accounts.account_id = tbl_fundsrc.fund_id and > tbl_fundsrc.fund_id = tbl_codes.code_id > order by tbl_accounts.account_id, tbl_fundsrc.fund_id ></cfquery> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
