Information from 2 tables

  • Thread starter open a adobe file from a command button
  • Start date
O

open a adobe file from a command button

How do you place information from 2 or more tables on one form. I want to
count the records from one table, count the records from another table,
divide one by the other but place all the information on a form. I get one
total but the source of the form is one of the tables. Can you place math
products on a form without a source??
 
D

Douglas J. Steele

There are a few options. One is to use a subform (which needn't be linked to
the main form if it's not appropriate). Another is to create a function that
returns the value in question, and use it as the control source for an
unbound textbox. Depending on the situation, you may be able to join the two
tables together in a query, and use that query as the record source for your
form.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



"open a adobe file from a command button"
 
Top