sorting/filtering data

[nn92]

Hi, I have to make a simple query in access,
here are the pictures which explain what is to be done.








So, I want to achieve somthing like upper picture, but I dont know how to organize it on lower picture...



Thanks in advance...

[ranman256]

there are no pictures.

you can make a simple filter for any form:
put a text box on the form (txtFind),
set the afterupdate event:

sub txtFind_Afterupdate()
If IsNull(txtFind) Then
   Me.FilterOn = False
Else
   Me.Filter = "[ItemName] like '*" & me.txtFind & "*'"
   Me.FilterOn = True
End If
end sub

[nn92]

I reuploaded the pictures and changed the question...
can you please have a look to the question now?

[nn92]

I reuploaded the pictures and changed the question...
can you please have a look to the question now?

[ranman256]

in the query design, dbl-click the field in the table, it will then appear in the query grid.
if you want to sort, click sort box and choose ASC, or DESC

this is basic access 101. Find a book on it for review.

[ssanfu]

What you are looking for is called an Aggregate query.

Maybe start with these sites:

SQL Aggregation queries using Group By, Sum, Count and Having
https://www.youtube.com/watch?v=IVMfDpCGwK4

Aggregate Queries Count Example Access 2013
https://www.youtube.com/watch?v=YE_7kchsqbA

SQL Using Aggregate Functions (Programming In Access 2013) by Steve bishop
https://www.youtube.com/watch?v=CgBcI8rq10k

Use Aggregate Functions in a Query
https://www.youtube.com/watch?v=hKIlwIVci5w

Aggregate Function Queries in Access – Tutorial and Instructions
https://www.teachucomp.com/aggregate...cess-tutorial/