Adding a new column to a query in code

[Gus]

Hello there

Is there any way to add a column to a query using code ?

Thanks

Gus

 

[Ken Snell [MVP]]

Do you want to modify an existing query so that an additional field is part
of the query's output? Please provide more details.

 

[Gus]

Yes, that is correct. I added couple of new fields to the
underlying tables, and now I want to add the same fields
to the query, so that the field is part of the output]

Thanks
Gus

 

[Ken Snell [MVP]]

Is the query a saved query? If yes, open it in design view and add those
fields to the query's list of fields.

If you're building the SQL statement in code, then just add those fields
into the SQL statement that you're building.

Maybe I'm missing something here?

--

Ken Snell
<MS ACCESS MVP>

Yes, that is correct. I added couple of new fields to the
underlying tables, and now I want to add the same fields
to the query, so that the field is part of the output]

Thanks
Gus

-----Original Message-----
Do you want to modify an existing query so that an additional field is part
of the query's output? Please provide more details.

--

Ken Snell
<MS ACCESS MVP>




.