DataBase - adding a field to an existing query

Hello all. I have several queries that i need to add the uniqueID field to so
that they can be shown in reports already setup.

When i setup the queries i did not think i would need the uniqueID field so
it was not added when the query was first constructed.

Is there a way (an easy way) of adding a field to a query that has already
been built?

thanks

Yes. Re-edit it, in design view, drag the field into the grid, or in SQL
view, in the SELECT clause.


Hoping it may help,
Vanderghast, Access MVP

Hi Michael, when i open the query in design view the field i want to add to
the query is not in the field list, this is my problem. When i originally
setup the query from a table, i did not add the uniqueID field, therefore it
is not available when i open the query to edit.

Do i have to start from scratch(i have several queries where i need to add
this field.
I am unsure if this is important, but this uniqueID field is not used in the
query itself but i need it to be shown in the report that is generated by the
query. Does any of this make sense?

You have to trace one query that will be able to see the table with the
field. In that query, add the field, and do the same until you finally reach
your final query.



Vanderghast, Access MVP

thanks Michel,

i had just discovered where i was going wrong and you have confirmed it. I
did not realise that the query i am trying to add the uniqueID field too was
based on another query. All is obvious to me now. Thanks for your help.