a query from 2 related tables

[Liat]

Hello,

I have a main table, payments table and estimations table.
(The ID of the main table equals suitID that exists in
both payments and estimations tables)

I would like to create a query that gives, for example,
all the estimations and payments for certain date.

How can I make this query on 2 different tables?

I tried to create a query using design view , but it
isn't good... (I put both esatimations and payments in
the fields of the query)

Thanks a lot,
Liat
..

 

[John Vinson]

Hello,

I have a main table, payments table and estimations table.
(The ID of the main table equals suitID that exists in
both payments and estimations tables)

I would like to create a query that gives, for example,
all the estimations and payments for certain date.

How can I make this query on 2 different tables?

I tried to create a query using design view , but it
isn't good... (I put both esatimations and payments in
the fields of the query)

Thanks a lot,
Liat
.

This isn't at all easy in a single Query, since there is no
relationship between Estimations and Payments. A query - by design -
has one record for every valid combination of records in the
constituent tables.

Generally, however, users should not be seeing a query datasheet
anyway! Forms are the appropriate tool for displaying data onscreen;
Reports are designed for printing data. In either case you can use a
Form (Report) with two Subforms (subreports); base the Form on the
main table, and one Subform on Payments and another subform (adjacent
or beneath the first subform) for estimations. It's not necessary to
create a single query to do this!

John W. Vinson[MVP]
(no longer chatting for now)