Adding a new column to a query in code

  • Thread starter Thread starter Gus
  • Start date Start date
Do you want to modify an existing query so that an additional field is part
of the query's output? Please provide more details.
 
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
 
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>

Gus said:
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>




.
Click to expand...
Click to expand...
 
Back
Top