count each person's driving time

  • Thread starter Thread starter Kath
  • Start date Start date
K

Kath

How to set up the report to count times if three
conditions are met during a certain month.
I have a database for three people car pooling.

The data table goes
Date(LongDate) DriverName PeopleInCar
Mon. Sept xx, 04 AA AABBCC
Tue. Sept xx, 04 BB AABBCC
--- --- -- -- CC AABBCC
--- --- -- -- AA AABB
--- --- -- -- BB AABB
etc...

So, in the monthly report, which I'd like to know how to
tell the report to select from which month, I want to
count how many times AA, BB, CC each drove with either all
three in the car, or just either AABB, or AACC, or BBCC in
the car so it is certain that everyone drive their fair
share. I know how to use the text box to summarize, but
don't know how to get it to count each driver's total
times driver with the different combinations.
Please help!
Thanks!
Kath
 
You can filter by month simply by including the data in
the underlying query for the report and set the format to
either mm or mmm and put [Enter month] in the criteria
field. As far as grouping by driver and riders this
should be done in the report, than you can sum the mileage
(if applicable) in the group footers.
Hope this helps.
Fons
 
I don't need to sum mileage. I needed to count the times
each driver had driven with a certain group of passengers.
How do I set it up for counting how many times AA had
driven with PeopleInCar being AABBCC or AACC, etc.
What expression formula do I use? I know how in Excel
with =Countif.
Thank you in advance!
-----Original Message-----
You can filter by month simply by including the data in
the underlying query for the report and set the format to
either mm or mmm and put [Enter month] in the criteria
field. As far as grouping by driver and riders this
should be done in the report, than you can sum the mileage
(if applicable) in the group footers.
Hope this helps.
Fons
-----Original Message-----
How to set up the report to count times if three
conditions are met during a certain month.
I have a database for three people car pooling.

The data table goes
Date(LongDate) DriverName PeopleInCar
Mon. Sept xx, 04 AA AABBCC
Tue. Sept xx, 04 BB AABBCC
--- --- -- -- CC AABBCC
--- --- -- -- AA AABB
--- --- -- -- BB AABB
etc...

So, in the monthly report, which I'd like to know how to
tell the report to select from which month, I want to
count how many times AA, BB, CC each drove with either all
three in the car, or just either AABB, or AACC, or BBCC in
the car so it is certain that everyone drive their fair
share. I know how to use the text box to summarize, but
don't know how to get it to count each driver's total
times driver with the different combinations.
Please help!
Thanks!
Kath
.
Click to expand...
.
Click to expand...
 
Once you have sutup the query and report as I outlined in
the earlier message, you can summarize in the group footer
any way desired, this could also be counts.
Let us assume you have created the report, than the reult
would be (in the Occupant footer)
Month Driver Occupants Count
1 AA AABB 3
1 AA AACC 4
(and in the driver footer)
1 AA 7
(than for the next occupant footer)
1 BB AABBCC 6
etc.
In the report Sorting/Grouping you would sort by month,
and by Driver and by Occupant, You probably want to have
a group footer for the Occupant and for the Driver
You would put the textboxes for the Month, Driver,
Occupant, and Count in the Occupant footer,
Than put textboxes for Month, Driver, and Count in the
Driver Footer.
Hope this helps.
Fons
-----Original Message-----
I don't need to sum mileage. I needed to count the times
each driver had driven with a certain group of passengers.
How do I set it up for counting how many times AA had
driven with PeopleInCar being AABBCC or AACC, etc.
What expression formula do I use? I know how in Excel
with =Countif.
Thank you in advance!
-----Original Message-----
You can filter by month simply by including the data in
the underlying query for the report and set the format to
either mm or mmm and put [Enter month] in the criteria
field. As far as grouping by driver and riders this
should be done in the report, than you can sum the mileage
(if applicable) in the group footers.
Hope this helps.
Fons
-----Original Message-----
How to set up the report to count times if three
conditions are met during a certain month.
I have a database for three people car pooling.

The data table goes
Date(LongDate) DriverName PeopleInCar
Mon. Sept xx, 04 AA AABBCC
Tue. Sept xx, 04 BB AABBCC
--- --- -- -- CC AABBCC
--- --- -- -- AA AABB
--- --- -- -- BB AABB
etc...

So, in the monthly report, which I'd like to know how to
tell the report to select from which month, I want to
count how many times AA, BB, CC each drove with either all
three in the car, or just either AABB, or AACC, or BBCC in
the car so it is certain that everyone drive their fair
share. I know how to use the text box to summarize, but
don't know how to get it to count each driver's total
times driver with the different combinations.
Please help!
Thanks!
Kath
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Ah ha! Got it. I was looking at the report page only
until you mention query! Got it and it is wonderful!
Thank you so much for your patience with me. ~_~

Kath
-----Original Message-----
Once you have sutup the query and report as I outlined in
the earlier message, you can summarize in the group footer
any way desired, this could also be counts.
Let us assume you have created the report, than the reult
would be (in the Occupant footer)
Month Driver Occupants Count
1 AA AABB 3
1 AA AACC 4
(and in the driver footer)
1 AA 7
(than for the next occupant footer)
1 BB AABBCC 6
etc.
In the report Sorting/Grouping you would sort by month,
and by Driver and by Occupant, You probably want to have
a group footer for the Occupant and for the Driver
You would put the textboxes for the Month, Driver,
Occupant, and Count in the Occupant footer,
Than put textboxes for Month, Driver, and Count in the
Driver Footer.
Hope this helps.
Fons
-----Original Message-----
I don't need to sum mileage. I needed to count the times
each driver had driven with a certain group of passengers.
How do I set it up for counting how many times AA had
driven with PeopleInCar being AABBCC or AACC, etc.
What expression formula do I use? I know how in Excel
with =Countif.
Thank you in advance!
-----Original Message-----
You can filter by month simply by including the data in
the underlying query for the report and set the format to
either mm or mmm and put [Enter month] in the criteria
field. As far as grouping by driver and riders this
should be done in the report, than you can sum the mileage
(if applicable) in the group footers.
Hope this helps.
Fons
-----Original Message-----
How to set up the report to count times if three
conditions are met during a certain month.
I have a database for three people car pooling.

The data table goes
Date(LongDate) DriverName PeopleInCar
Mon. Sept xx, 04 AA AABBCC
Tue. Sept xx, 04 BB AABBCC
--- --- -- -- CC AABBCC
--- --- -- -- AA AABB
--- --- -- -- BB AABB
etc...
So, in the monthly report, which I'd like to know how to tell the report to select from which month, I want to
count how many times AA, BB, CC each drove with either
all three in the car, or just either AABB, or AACC, or
Click to expand...
Click to expand...
Click to expand...
BBCC in the car so it is certain that everyone drive their
fair share. I know how to use the text box to summarize,
 
Glad to be of help. And thanks for your reply.
Fons
-----Original Message-----
Ah ha! Got it. I was looking at the report page only
until you mention query! Got it and it is wonderful!
Thank you so much for your patience with me. ~_~

Kath
-----Original Message-----
Once you have sutup the query and report as I outlined in
the earlier message, you can summarize in the group footer
any way desired, this could also be counts.
Let us assume you have created the report, than the reult
would be (in the Occupant footer)
Month Driver Occupants Count
1 AA AABB 3
1 AA AACC 4
(and in the driver footer)
1 AA 7
(than for the next occupant footer)
1 BB AABBCC 6
etc.
In the report Sorting/Grouping you would sort by month,
and by Driver and by Occupant, You probably want to have
a group footer for the Occupant and for the Driver
You would put the textboxes for the Month, Driver,
Occupant, and Count in the Occupant footer,
Than put textboxes for Month, Driver, and Count in the
Driver Footer.
Hope this helps.
Fons
-----Original Message-----
I don't need to sum mileage. I needed to count the times
each driver had driven with a certain group of passengers.
How do I set it up for counting how many times AA had
driven with PeopleInCar being AABBCC or AACC, etc.
What expression formula do I use? I know how in Excel
with =Countif.
Thank you in advance!

-----Original Message-----
You can filter by month simply by including the data in
the underlying query for the report and set the format to
either mm or mmm and put [Enter month] in the criteria
field. As far as grouping by driver and riders this
should be done in the report, than you can sum the
mileage
(if applicable) in the group footers.
Hope this helps.
Fons
-----Original Message-----
How to set up the report to count times if three
conditions are met during a certain month.
I have a database for three people car pooling.

The data table goes
Date(LongDate) DriverName PeopleInCar
Mon. Sept xx, 04 AA AABBCC
Tue. Sept xx, 04 BB AABBCC
--- --- -- -- CC AABBCC
--- --- -- -- AA AABB
--- --- -- -- BB AABB
etc...
So, in the monthly report, which I'd like to know how
Click to expand...
to tell the report to select from which month, I want to
count how many times AA, BB, CC each drove with either
all three in the car, or just either AABB, or AACC, or
Click to expand...
Click to expand...
BBCC in the car so it is certain that everyone drive their
fair share. I know how to use the text box to summarize,
but don't know how to get it to count each driver's total
Click to expand...
.
Click to expand...
 
Back
Top