query not showing new records

[Guest]

I am new to Access. I have a functional database with several tables that is
working just fine (product table, category table etc).

The problem: I have added new records to my product table, however, when I
run an existing query on this table, along with several other tables, the new
records do not show.
The new records show in the product table just fine. What's going on?
Do I have to update the query somehow so that it knows there are new records?
thx,
toby

 

[David F Cox]

"along with other tables" might indicate that you have a join in your query
to another table, and it may be that you need to add some records to that
before your query works as you hope.

You could look at the QBE grid of your query and see if the product table is
linked to another table, and that will give you a hint. If you still do not
see the reason go to SQL view of your query and cut and paste the SQL code
to this newsgroup.

 

[Guest]

Not sure what the QBE grid is, but I did see the table links for this query,
and the tbl_products is linked to the tbl_finishes via the field "finish
name" in both tables. Below is the sql from the query.

And tbl_product still looks fine as far as my new records which are there.

SELECT
tbl_products.product_ID, tbl_products.product_code,
tbl_products.product_name, tbl_products.category, tbl_products.product_desc,
tbl_products.Supplier AS tbl_products_Supplier, tbl_products.line_name,
tbl_products.image_thumb, tbl_products.thumb_width AS
tbl_products_thumb_width, tbl_products.thumb_height AS,
tbl_products.alt_image_height, tbl_products.image_alt_text,
tbl_products.finish_name AS tbl_products_finish_name,
tbl_finishes.finish_name AS tbl_finishes_finish_name,
tbl_finishes.finish_abbrev, tbl_finishes.finish_descr,
tbl_finishes.thumb_Location, tbl_finishes.thumb_width AS
tbl_finishes_thumb_width, tbl_finishes.thumb_height AS
tbl_finishes_thumb_height, tbl_finishes.large_location, tbl_finishes.supplier
AS tbl_finishes_supplier
FROM tbl_finishes INNER JOIN tbl_products ON tbl_finishes.finish_name =
tbl_products.finish_name;

 

[Van T. Dinh]

QBE grid: Query By Example grid which is the usual Design View for Query.

From the SQL String, it looks like the new Records for tbl_Products don't
have corresponding Record(s) from Table tbl_finishes.

As a *test*, change INNER JOIN to RIGHT JOIN to see if the new Records
appear in the DatasheetView of the Query.

If they do, then you may need to decide whether you need the corresponding
REcords in tbl_finishes and change back to INNER JOIN or simply leave your
Query with RIGHT JOIN without corresponding Record(s).

 

[David F Cox]

The query has an inner join, it will only show products with a valid finish
name. Could that be the problem?

 

[Guest]

Thanks!
That was it. I went to the tbl_products and found the field there for the
"finish name" and then selected the finish name for each new record; once I
did that the query showed my new records!

Thanks again.