By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Drag fieldnames into query

P: n/a
In the query builder I made an edit-query in which I have linked table A to
table B on IDnr. For every record that matches I want 5 fields of table A to
get the values of corresponding fields in table B. I'm able to make this
query but only by typing the table B fieldnames in the 'change to'-row. Is
there some easy way to drag those fieldnames to that row or another way to
make this easier?
Thanks,
john
Nov 17 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can drag the tablB fields into their own space in the grid. You would
then be able to copy and past, first the tblB tablename and then the tblB
fieldName and the put a dot between them.
Only worth doing if the table and field names are complex and typing error
prone.

Kevin C

"john" <jo**@test.comwrote in message
news:Mv********************@casema.nl...
In the query builder I made an edit-query in which I have linked table A
to table B on IDnr. For every record that matches I want 5 fields of table
A to get the values of corresponding fields in table B. I'm able to make
this query but only by typing the table B fieldnames in the 'change
to'-row. Is there some easy way to drag those fieldnames to that row or
another way to make this easier?
Thanks,
john

Nov 17 '06 #2

P: n/a
OK, thanks.
john

"Kc-Mass" <co********@comcast.netschreef in bericht
news:P8******************************@comcast.com. ..
You can drag the tablB fields into their own space in the grid. You would
then be able to copy and past, first the tblB tablename and then the tblB
fieldName and the put a dot between them.
Only worth doing if the table and field names are complex and typing error
prone.

Kevin C

"john" <jo**@test.comwrote in message
news:Mv********************@casema.nl...
>In the query builder I made an edit-query in which I have linked table A
to table B on IDnr. For every record that matches I want 5 fields of
table A to get the values of corresponding fields in table B. I'm able to
make this query but only by typing the table B fieldnames in the 'change
to'-row. Is there some easy way to drag those fieldnames to that row or
another way to make this easier?
Thanks,
john


Nov 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.