Can yourefresh a table in Query Design view

HealthyB1

Registered User.
Local time
Tomorrow, 04:18
Joined
Jul 21, 2013
Messages
103
G'day,
I have created a query in query design view and it works ok on the two tables I am using. I have now added an extra field to one of the two tables (tblVehicle).
If I drag a new copy of the table into the existing query in design view it is now called (tblVehicle1). Examination of same reveals the new field added.
To make the query work I new need to change source table name for each field in the query from tblVehicle to tblVehicle1

Question:- Is it possible to refresh the original table tblVehicle and thus save time?? :confused:
 
Just close and reopen your original query - the extra field should be in the table representation on the query designer.
 
set the Alias of tblVehicle1 to tblVehicle.
 

Users who are viewing this thread

Back
Top Bottom