Query Problems

[NotGood@All]

I have 2 tables with a 1 to many relationship. There are 3000 records in
table1, but only 1500 in table2 because there is nothing attached to table2.
I need to see all the records regardless. Is there an update query I can use
to enter a “N/A†in one of the fields in table2 so all 3000 records show

 

[Ed Metcalfe]

I have 2 tables with a 1 to many relationship. There are 3000 records in
table1, but only 1500 in table2 because there is nothing attached to
table2.
I need to see all the records regardless. Is there an update query I can
use
to enter a "N/A" in one of the fields in table2 so all 3000 records show

What is the SQL of your query?

Ed Metcalfe.

 

[Kristibaer]

I am in the middle of a similar query joining tables with different numbers
of records. Try this:

In the Design View, assuming you have a field of each table linked,
right-click the join line between tables to select "Join Properties". (This
can be tricky...you may first see a long list of options, what you should see
are 2: Join Properties and Remove Link. You may need to try postiioning the
mouse pointer a few times to see the correct option list).

In Join Properties you will see 3 options; all records from one table and
only those that match from the other (both directions) and only records where
values are equal. If you select the option to show all records from the
table with 3000 records and only records from the other table that match, you
should see 3000 records displayed.

Sometimes the results displayed using the join properties will produce
duplicate records. If this occurs, go back to design, highlight the column
with duplicate results, right click and select Totals. This should add a row
to the design view called "Group By" which should eliminate any duplicates.

 

[open a adobe file from a command button]

That worked, thank you very much

I am in the middle of a similar query joining tables with different numbers
of records. Try this:

In the Design View, assuming you have a field of each table linked,
right-click the join line between tables to select "Join Properties". (This
can be tricky...you may first see a long list of options, what you should see
are 2: Join Properties and Remove Link. You may need to try postiioning the
mouse pointer a few times to see the correct option list).

In Join Properties you will see 3 options; all records from one table and
only those that match from the other (both directions) and only records where
values are equal. If you select the option to show all records from the
table with 3000 records and only records from the other table that match, you
should see 3000 records displayed.

Sometimes the results displayed using the join properties will produce
duplicate records. If this occurs, go back to design, highlight the column
with duplicate results, right click and select Totals. This should add a row
to the design view called "Group By" which should eliminate any duplicates.