I am new to this forums...

I wanted an help on a query

I have 3 access table

1. Manufacture Table - contains info about manufacturers
    * mfr_id
    * mfr_name
    * mfr_address
2. Products Table - contains info about manufacturers products. An manuf may have more than one product and we use the mfr ID to link the product to the manuf.
    * product_id
    * mfr_id
    * product_name
    * cat_id1
    * cat_id2
    * cat_id3
    * newest
3. Category Table - contains info on the categories and their names
    * cat_id
    * cat_name

* are the fields for the table

The field "newest" in the table "Products" is an integer. Higher the value the newer the product is.

I want an SQL query to get one product per mfr and the product should be the one with the highest newest value.

I would really like some help on the query.

You have to inner_join the tables.
Then just order the records that will come to you from your query by the newest_product and use "DESC". The record that you`ll take is the one you are looking for.