Hi,
I'm working with two recordSets. The first grabs a list of meters and the corresponding maximum for each meter throughout the month. The second grabs different readings for each meter, and only on select days.
What I am wanting to do is to come up with a recordSet that has the maximum reading (from either of the two) for each meter. Is this possible?
Any help is appreciated. Thanks
I'm working with two recordSets. The first grabs a list of meters and the corresponding maximum for each meter throughout the month. The second grabs different readings for each meter, and only on select days.
What I am wanting to do is to come up with a recordSet that has the maximum reading (from either of the two) for each meter. Is this possible?
Any help is appreciated. Thanks