query to display last four entries

[mejia.j88]

Hi all,



i have a table that saves the following information:

Furnace Asset Number, heating zone 1, heating zone 2, etc etc, heating zone 10.

i have created a form in which the user selects the furnace asset number from a cbo box, and populates 10 text boxes with its respective heating zone temps.

we only have 4 furnaces which are saved onto this table; and only need to display the last record for each furnace.

in other words: i want my cbo box to display the asset numbers drawn from the table via query, BUT only want it to draw the last record for each four asset numbers. the cbo should display 4 choices, asset 1, 2, 3, 4, and when selected, the text boxes should be filled in with the most current temps for the asset number chosen.

how do i set up such a query?

i have this set up, but no filters:

SELECT tbl_pre_post.Asset_No, tbl_pre_post.Date_Time, tbl_pre_post.Zone_0, tbl_pre_post.Zone_1, tbl_pre_post.Zone_2, tbl_pre_post.Zone_3, tbl_pre_post.Zone_4, tbl_pre_post.Zone_5, tbl_pre_post.Zone_6, tbl_pre_post.Zone_7, tbl_pre_post.Zone_8, tbl_pre_post.Zone_9FROM tbl_pre_post;


thanks guys/gals

[pbaldy]

See if this works for you:

ACC: How to Create a Top N Values per Group Query

[mejia.j88]

i'll check it out and get back to you if things work/dont work.

thanks pbaldy1