Hi,
I am looking for query to retrieve Minimum and maximum value in the field if text is existed.
Example:
ID
--------------------------
245
246
278
358
John
9857
Richard
6547
2540
Thanks.
Hi,
I am looking for query to retrieve Minimum and maximum value in the field if text is existed.
Example:
ID
--------------------------
245
246
278
358
John
9857
Richard
6547
2540
Thanks.
Use the query builder and build a Totals (GROUP BY) query using Min() and Max() aggregate functions.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Can you please explain me how?
This is basic Access functionality. Open the query builder, pick table, pull fields to grid, click Totals on the ribbon, set criteria in the grid. Access Help has more guidelines on using the query builder.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.