Gridtable calculate and count data entry

Sir,

The output is showing wrong.

As per grid data output is not correct.

It is not counting proper data.

I need how much books count in category  as issued, not issued,  missing.

Total is how much entry of same book name.

total count I can verify by formula physically. ...

Total = issued + not issued + missing

I want to veryfy it by physical count of books. And tally with this grid table.

Means

1. How much entry of same book i. e total
2. How much book fall in issued category
3. How much book fall in not issued category
4. How much book fall in missing category.

Please check and help

Thanks

Nitin ingale

Sir,

I want to count data entry. You have send file in that,  I ask how many in group home, work, & friends category. And total is how much entry of people.
While in search, it's display all data and I can filter data. Now I want to count how much are friend, work and home category belong to all people.

Similarly in my project I want to count book record. how much in issued, not issued and missing category. From total same books name. Similar to above employee project. But I need count.

It is saving in book combo box of book status.

Please help
How we can count data from grid table and display in different table.
Count should be. .
1. No of same book name
2. No of same book in issued
3. No of same book in not issued
4. No of same book in missing

Thanks
Nitin ingale

Sir,

Thank you sir.

In my database I need to count same book name as well as its status count.

Please see sample file.
In book stock record grid table, I created manually data entries.

Please, can you write SQL Query in button. So that data can be auto created.

Thanks

Nitin ingale

Sir,
Please see update file,

I am able to count the books but not the respective books status.
Please tell how to do this.

I need the ...
1. count of same book name
2. Count of above same book in issued
3. Count of above book in not issued
4. Count of above book in missing

But in inventory I need to count books and it's status that is issued. , not issued. , missing.
In inventory how many book, and it's status, in number as count I need to maintain.
Please see the file inventory, help how we can display query.

Thank you
Nitin ingale

Sir,
I simplify the database structure.

I need output in grid table 2 that is...

1. "Total count" of same book name
2. Count of above same book in "issued"
3. Count of above book in "not issued"
4. Count of above book in "missing"

Please see attached file. And see SQL butten program written and please correct it.

Please sir. solve the query .

Thank you
Nitin ingale