Can yourefresh a table in Query Design view (1 Viewer)

HealthyB1

Registered User.
Local time
Today, 13:06
Joined
Jul 21, 2013
Messages
82
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:
 

Minty

AWF VIP
Local time
Today, 04:36
Joined
Jul 26, 2013
Messages
9,369
Just close and reopen your original query - the extra field should be in the table representation on the query designer.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 11:36
Joined
May 7, 2009
Messages
16,788
set the Alias of tblVehicle1 to tblVehicle.
 

Users who are viewing this thread

Top Bottom