yes, i had 1 one as number and two as text when all 3 needed to be numbers. thanks!
-----Original Message----- From: Mary Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:27 AM To: SQL Subject: Re: Type mismatch in expression 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> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
