A andrewm andrewm Local time Tomorrow, 01:16 Joined Jan 21, 2005 Messages 13 Jan 21, 2005 #1 I have two tables which several update queries are used related to several fields. Can I make it simple by puting all the queries into one Andrewm
I have two tables which several update queries are used related to several fields. Can I make it simple by puting all the queries into one Andrewm
mresann Registered User. Local time Today, 08:46 Joined Jan 11, 2005 Messages 357 Jan 21, 2005 #2 Yes. The easiest way is to use the Query grid. In Update Query mode, include all the fields you want updated.
Yes. The easiest way is to use the Query grid. In Update Query mode, include all the fields you want updated.
P Pat Hartman Super Moderator Staff member Local time Today, 11:46 Joined Feb 19, 2002 Messages 47,594 Jan 21, 2005 #3 If you are asking "can a querydef contain multiple separate queries the way a stored procedure can?", the answer is no.
If you are asking "can a querydef contain multiple separate queries the way a stored procedure can?", the answer is no.
