Hi, Running the following query in MS Access query designer.
SELECT [Prostheses List].[Billing Code] AS mbs_item_no, [Prostheses List].MinBenefit AS mbs_item_cost, [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, [Prostheses List].[Product Name] AS desc1, [Prostheses List].[Further Description] AS desc2, [Prostheses List].Size AS desc3 FROM [Prostheses List] WHERE ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) ORDER BY [Prostheses List].[Billing Code]; it works fine. When I run it in CF, I get the following error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect After some investigation I think the error is related to the question mark character in the where clause. I cannot change the field name in the table, as it is provided by the Federal government. I've tried text quotes around the field name.. but nothing has worked.... Any idea to get around this? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
