Add Field To An Export Query

[access2010]

We have a Query that is used to create a Cvs file and we have been trying to add an extra field to be exported without success.

The field is = Price_Previous

Your assistance will be appreciated.

Nicole

 

[June7]

Field is in the query. So what is the issue?

 

[access2010]

Field is in the query. So what is the issue?

Thank you June7 for your reply.

Our problem is that we have tried many times without success and have been unable to update our query to work.

Would you be so kind as to advise us where the = Price_Previous = field should be entered?

Thank you.
Crystal

 

[arnelgp]

you may check this also.

 

[access2010]

you may check this also.

P.E.R.F.E.C.T. thank you arnelgp

Crystal

 

[Pat Hartman]

The answer in case anyone cares, is that the code was not using the querydef it was using embedded SQL. The OP had modified the querydef but had not modified the embedded SQL in the VBA code, nor the export code.

The procedure could have simply used the TransferText instead of VBA. I modified the querydef to add the field and do the formatting fixes.

I also added Option Explicit. You should change this setting in the Access option to Declare all variables. You will have to add the line to any code module created prior to you changing the setting (Open VBA editor, Tools/Options/Editor). AND you will need to fix any compile errors that exist because your variables were not defined.

 

[access2010]

The answer in case anyone cares, is that the code was not using the querydef it was using embedded SQL. The OP had modified the querydef but had not modified the embedded SQL in the VBA code, nor the export code.

The procedure could have simply used the TransferText instead of VBA. I modified the querydef to add the field and do the formatting fixes.

I also added Option Explicit. You should change this setting in the Access option to Declare all variables. You will have to add the line to any code module created prior to you changing the setting (Open VBA editor, Tools/Options/Editor). AND you will need to fix any compile errors that exist because your variables were not defined.

Thank you Pat for your suggestion.

Nicole

 

[Pat Hartman]

You're welcome