Max value for a single date/multiple time/single tag ID combination

[clemensh]

Hi, thanks in advance for any help you can offer. I've got a table that has

Date
Time
Tag ID
Power Level

throughout the day a computer listens to several tags (transmitters) and records the power level of the signal generated by the tag each 3 seconds. What I'd like to do is build a query that gives the Date, Time and Maximum Power level reading for each tag ID. I only want 1 record per tag per day

I've tried using "group by" and max in the query but this gives me all the times throughout the day.

anyway, thanks again for looking

cheers, Shaun

 

[Jon K]

You can remove the time field from your Totals Query.

Then, in a new query, join the Totals Query back to the table (i.e. by linking the fields in the Totals Query to the corresponding fields in the table) to get the required records from the table.
.

 

[clemensh]

Hi Jon, thanks a bunch for that..worked great

cheers, Shaun