Skip field in export specification

[fbs]

I run a query that I export out to a tab delimited file. This text file is used for another application. The problem I am having is if I select "skip field" in my text "export specification" it still exports out that piece of data, even though I have selected "Skip Field". The data type on this field is a number and field size is integer.

I thought I read in another access newsgroup that this is a known bug? Is that true? Is there a fix? I am anxious to fix this because, I have 90 query's that I export to text and I would hate to have to go to each query and select "Not Show" that field.

Help?

 

[fbs]

I am running Access 2002 SPK3.

As far as using a parameter query, not sure how that would work? I have never used a parameter query....

Some background information, this data is used in our publishing environment and each query represents a published table for one of our magazine issues. The query handles the ranking of a company, based on their reported revenue amount for a particular market. Each query also contains the pagination instructions for a Quark Xpress template, the exported results (.txt file) are then flowed into the appropriate text box within the Quark Template completely formatted for Quark Template.

 

[fbs]

Pat,

Thanks, I will take a look at the Parameter Query option.

I have not looked for the hotfix's yet