Manipulating records of 2 tables

[Praveen Manne]

HI,

How to manipulate records of 2 different tables on a form. Can anyone help
me in the correct syntax?

for eg: 23 is in table 1
and 75 is in table 2

how to add these two numbers on a form which is bounded to another table?

Thanks
Praveen

 

[Larry Linson]

HI,

How to manipulate records of 2 different tables on a form. Can anyone help
me in the correct syntax?

for eg: 23 is in table 1
and 75 is in table 2

how to add these two numbers on a form which is bounded to another table?

Np, without more specific information about how the tables in which these
numbers reside relate to the information on the form, no one is likely to be
able to give you more than generic help such as: look into the domain
aggregate function DLOOKUP in Help. That allows access to particular tables
that need not be the Recordsource of the Form.

If you can clarify, there's a good chance that someone can help, though.

Larry Linson
Microsoft Access MVP