Are you trying to change the field type on the fly within a predefined query or am I reading your question wrong?
--- On Mon, 11/30/09, jsivanan <[email protected]> wrote: From: jsivanan <[email protected]> Subject: [Access VBA Central] Programmically setting query computed field types? To: [email protected] Date: Monday, November 30, 2009, 11:34 AM I have about 200 queries that need to have the field type of 2 computed fieds to General Number versus the default: text. Is there a way to do this programmically? Can I specify the query, the name of the field and specify the type as General Number? Thanks, Jnana [Non-text portions of this message have been removed]
