still cannot found

[Guest]

sadly, my report still cannot count of books that's teacher borrowing.
In details ;
Teacher's name;
Book's name;
date of borrowing;
Notes;

l also need to count the numbers of teaching using library for borrowing
books .

Thanks in advance

 

[John Vinson]

sadly, my report still cannot count of books that's teacher borrowing.
In details ;
Teacher's name;
Book's name;
date of borrowing;
Notes;

l also need to count the numbers of teaching using library for borrowing
books .

Thanks in advance

If you're storing the teacher's name in the Borrowing table... your
design is probably wrong.

That said: create a Query based on this table. Select the book's name
and teacher's name field. View the query's Properties, and set the
"Unique Values" property to true. This will give one record for each
book that the teacher borrowed (no matter how many times that book was
borrowed).

Now create ANOTHER query based on this query. Make it a Totals query
by clicking the Greek Sigma icon - it looks like a sideways W. Group
By the teacher's name and select the Book's Name field *twice*; Group
By one instance and Count the other.

John W. Vinson[MVP]

 

[Duane Hookom]

If I understand correctly, you have a report that is grouped by Teacher and
displays books in the detail section. You should be able to display either a
header or a footer section for the teacher and add a text box with a control
source of:
=Count(*)
To count the number of different teachers, add a text box to the teacher
group header:
Name: txtCountTeach
Control Source: =1
Running Sum: Over All
Visible: No
Then add a text box to your report footer:
Control Source: =txtCountTeach

 

[Guest]

Thank you Duanne. l will try it and l think your answer its good enough . But
l have one more question , what is the different between "add mode" and "edit
mode" in
switchboard form. and l would like to create one form before l show my
switchboard thats in 3 seconds.but l confused how could l do it.

 

[Duane Hookom]

Next time please ask a new, un-related question in a new thread. You will
have a much wider audience.

Add mode is for adding new records. The previous records don't display when
the form opens. Edit mode will open the form and display existing records.

You can have any form set as the first form to be seen when an mdb opens.