Noob question on query design

[Joshcorp]

Hello All. I am sure that this question has a very simple answer, but given my inexperience with Access I am finding it quite vexing. Here is my problem:



I have two tables of data sorted by date and time in 5 minute increments. I have linked the two tables already, matching the date in the first table with the corresponding column in the second. Table 1 contains a column of the date/time and each record is unique. Table 2 has a similar column (the linked column) except that there are multiple records with the same date/time. I want to query out only the record that contains the minimum value for each unique date/time entry from table 1. I also want two more field items from table 2 that are specific to the record that contains the aforementioned minimum value.

I used the query designer to successfully return the minimum value I wanted to see for each unique Data/Time record. My problem is that when I attempt to add the other two fields to the query from table 2, it then gives me every single record for each date/time pair instead of just the full record set of the records containing the minimum value. I hope I have explained this well enough...

Any help is appreciated. Im sure this is a very simple problem for anyone semi proficient with Access but unfortunately I am just not quite there yet.

Thanks!!

[ssanfu]

You are probably using a totals query with something like MIN in the Totals row in the query grid. Since it is a totals query, all fields added to the grid come into play.

For this example:
Save the current query as "qryMin1". Create another query, add "Table2" and "qryMin1".
Link the query and table on the appropriate fields.
Drag down the fields in "qryMin1" and the two fields from Table2 that you want.

Execute the new query.

[Joshcorp]

That worked, thanks!!

[ssanfu]

No problem..Glar to help.

And welcome to the forum.....

(I'll mark this as solved for you)