Refresh query/table used in a query

[KrispyData]

Bear with me this question may sound confusing!

I have QueryB which is based off of QueryA. I made some changes to QueryA
(added more fields: Primary Acct Name and Prim Acct Number). When I go to
QueryB in design view, I notice that QueryA did not update with the newly
added fields. Do I need to delete QueryA in the design view and add it
again, and re-establish relationsships, in order for the newly added fields
to be available?

Thanks for your help!

 

[Jeff Boyce]

Yes.

Access is "remembering" the earlier version of the query. I would suggest:

* opening QueryB in design view
* adding another copy of QueryA (so you get the newer version)
* modifying all the fields you have in the 'grid' so they point to the new
version of QueryA, not the old.
* deleting the old version of QueryA from the space above the grid (note:
if you've 'switched' all the fields, none will disappear - and if you missed
switching some, those WILL disappear. You'll need to add those back in.)
* test run the query.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP