grand total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

l was create a total of book by categories but now l tried to get a grand
total of the books. l have tried so many times and l read answer from
discussion group but it doesn't help.
fiksyen=2356
language = 567
refrence=6789
others=89
thanks in advance
 
Since you didn't explain the underlying data structure, nor the
circumstances in which you are trying to do this, we can only guess...

Create a new query. Add your ID field to the grid. Click the Totals
button, and change the GroupBy to Count.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
thanks for your respond .with a little bit knowledge ,now l'm trying to help
my school library have their own information system. now , l have a report
of the book by a categories and a total of the book by categories .so now l
try to create the total of the book at the end of my report but it not
working. l hope you understand me now and please let me know if it didn't.
anyway l will try your advice on tuesday,because saturday,sunday and
monday are our public holiday. thanks in advance.
 
yes ,its done. based from query , l create a report. now l try to change a
word
from sum of the books to total of the books. is it possible.?
thaks for any help
 
I don't understand "sum of books" ... "sum" usually refers to adding up, but
books have nothing to add up.

"Total of books" is similar, but I'm assuming you meant "count" of books
(how many there are).

Can you describe what you are trying to do a bit more?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top