how can i count the number of times a name comes up in a query?

[Guest]

i have a database with alomost 700 names, with checkboxes checked off almost
daily. (Depends on those that show up)

how can i count howmany times they came going back to august 1 2006?

I have seperate feilds for first name and last name and date and visit

 

[Jeff Boyce]

We're not there. We can't see your table. We don't know what "checkboxes"
you are referring to.

General descriptions lead to general suggestions ...

To capture attendance in a date range, you'll need, at a minimum, a
date/time field and a person(ID) field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

My Database has 4 columns,auto ID Field, Person Number feild, Date feild, A
checkbox (yes/no) that i click if the person shows up.

how can i count howmany times each person came going back to august 1 2006?

 

[Jeff Boyce]

Create a query against your table (an Access "Database" is all of the parts,
not just a single table).

Add the PersonNumber field, add the Date field. (by the way, Access treats
the word "Date" as a reserved word -- use a different title for the field to
avoid confusing Access and yourself)

Use ">=#8/1/2006#" (without the quotes) as a selection criterion under your
[Date] field.

Click on the Totals button. Keep the "GroupBy" for [PersonNumber], change
it to "Count" for your [Date] field.

Run the query.

If you ONLY add rows to the table for those times (i.e., dates) a person
attends, you don't need to use the checkbox. If you add rows for every day
for every person, you'll need to also add the checkbox field, change the
"GroupBy" to "Where", uncheck the "Show" checkbox, and use "True" (without
the quotes) for the selection criteria.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi
In my quary i now have 3 columns, i followd your instructions, and as i run
the quary i dont get any results. all i see is athe titles count of date, and
Person Number. (i dont see the numbers that i am looking for)

Thanks so much for the help

Geisi

Create a query against your table (an Access "Database" is all of the parts,
not just a single table).

Add the PersonNumber field, add the Date field. (by the way, Access treats
the word "Date" as a reserved word -- use a different title for the field to
avoid confusing Access and yourself)

Use ">=#8/1/2006#" (without the quotes) as a selection criterion under your
[Date] field.

Click on the Totals button. Keep the "GroupBy" for [PersonNumber], change
it to "Count" for your [Date] field.

Run the query.

If you ONLY add rows to the table for those times (i.e., dates) a person
attends, you don't need to use the checkbox. If you add rows for every day
for every person, you'll need to also add the checkbox field, change the
"GroupBy" to "Where", uncheck the "Show" checkbox, and use "True" (without
the quotes) for the selection criteria.

Regards

Jeff Boyce
Microsoft Office/Access MVP

My Database has 4 columns,auto ID Field, Person Number feild, Date feild,
A
checkbox (yes/no) that i click if the person shows up.

how can i count howmany times each person came going back to august 1
2006?

 

[Guest]

hi again
if i take out the >=#8/1/2006 from the criteria i do get the numbers from
the begining of time.
how do i search from 8/1/06 till the present?
how do i search from 8/1/06 untill 9/1/06?

Thanks again

Hi
In my quary i now have 3 columns, i followd your instructions, and as i run
the quary i dont get any results. all i see is athe titles count of date, and
Person Number. (i dont see the numbers that i am looking for)

Thanks so much for the help

Geisi

Create a query against your table (an Access "Database" is all of the parts,
not just a single table).

Add the PersonNumber field, add the Date field. (by the way, Access treats
the word "Date" as a reserved word -- use a different title for the field to
avoid confusing Access and yourself)

Use ">=#8/1/2006#" (without the quotes) as a selection criterion under your
[Date] field.

Click on the Totals button. Keep the "GroupBy" for [PersonNumber], change
it to "Count" for your [Date] field.

Run the query.

If you ONLY add rows to the table for those times (i.e., dates) a person
attends, you don't need to use the checkbox. If you add rows for every day
for every person, you'll need to also add the checkbox field, change the
"GroupBy" to "Where", uncheck the "Show" checkbox, and use "True" (without
the quotes) for the selection criteria.

Regards

Jeff Boyce
Microsoft Office/Access MVP

My Database has 4 columns,auto ID Field, Person Number feild, Date feild,
A
checkbox (yes/no) that i click if the person shows up.

how can i count howmany times each person came going back to august 1
2006?

i have a database with alomost 700 names, with checkboxes checked off
almost
daily. (Depends on those that show up)



I have seperate feilds for first name and last name and date and visit

 

[Jeff Boyce]

Check Access HELP on queries. The criteria of >=#8/1/2006# tells Access to
find any/all records that have a value greater than or equal to 8/1/2006.

Unless, of course, the field you called [Date] is NOT an Access Date/Time
field, but is something else... Did you use the Date/Time data type for
this field, or ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

hi again
if i take out the >=#8/1/2006 from the criteria i do get the numbers from
the begining of time.
how do i search from 8/1/06 till the present?
how do i search from 8/1/06 untill 9/1/06?

Thanks again

Hi
In my quary i now have 3 columns, i followd your instructions, and as i
run
the quary i dont get any results. all i see is athe titles count of date,
and
Person Number. (i dont see the numbers that i am looking for)

Thanks so much for the help

Geisi

Create a query against your table (an Access "Database" is all of the
parts,
not just a single table).

Add the PersonNumber field, add the Date field. (by the way, Access
treats
the word "Date" as a reserved word -- use a different title for the
field to
avoid confusing Access and yourself)

Use ">=#8/1/2006#" (without the quotes) as a selection criterion under
your
[Date] field.

Click on the Totals button. Keep the "GroupBy" for [PersonNumber],
change
it to "Count" for your [Date] field.

Run the query.

If you ONLY add rows to the table for those times (i.e., dates) a
person
attends, you don't need to use the checkbox. If you add rows for every
day
for every person, you'll need to also add the checkbox field, change
the
"GroupBy" to "Where", uncheck the "Show" checkbox, and use "True"
(without
the quotes) for the selection criteria.

Regards

Jeff Boyce
Microsoft Office/Access MVP

My Database has 4 columns,auto ID Field, Person Number feild, Date
feild,
A
checkbox (yes/no) that i click if the person shows up.

how can i count howmany times each person came going back to august 1
2006?

i have a database with alomost 700 names, with checkboxes checked
off
almost
daily. (Depends on those that show up)



I have seperate feilds for first name and last name and date and
visit

 

[Guest]

it is indeed a date/time type feild.
i created an other quary by date (between 8/1/06 and 2/20/07) and then i ran
this quary from the first one and that works. (i know that this cant be the
best wayto do this, but hey.......... )
Thanks so much,

Check Access HELP on queries. The criteria of >=#8/1/2006# tells Access to
find any/all records that have a value greater than or equal to 8/1/2006.

Unless, of course, the field you called [Date] is NOT an Access Date/Time
field, but is something else... Did you use the Date/Time data type for
this field, or ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

hi again
if i take out the >=#8/1/2006 from the criteria i do get the numbers from
the begining of time.
how do i search from 8/1/06 till the present?
how do i search from 8/1/06 untill 9/1/06?

Thanks again

Hi
In my quary i now have 3 columns, i followd your instructions, and as i
run
the quary i dont get any results. all i see is athe titles count of date,
and
Person Number. (i dont see the numbers that i am looking for)

Thanks so much for the help

Geisi

:

Create a query against your table (an Access "Database" is all of the
parts,
not just a single table).

Add the PersonNumber field, add the Date field. (by the way, Access
treats
the word "Date" as a reserved word -- use a different title for the
field to
avoid confusing Access and yourself)

Use ">=#8/1/2006#" (without the quotes) as a selection criterion under
your
[Date] field.

Click on the Totals button. Keep the "GroupBy" for [PersonNumber],
change
it to "Count" for your [Date] field.

Run the query.

If you ONLY add rows to the table for those times (i.e., dates) a
person
attends, you don't need to use the checkbox. If you add rows for every
day
for every person, you'll need to also add the checkbox field, change
the
"GroupBy" to "Where", uncheck the "Show" checkbox, and use "True"
(without
the quotes) for the selection criteria.

Regards

Jeff Boyce
Microsoft Office/Access MVP

My Database has 4 columns,auto ID Field, Person Number feild, Date
feild,
A
checkbox (yes/no) that i click if the person shows up.

how can i count howmany times each person came going back to august 1
2006?

i have a database with alomost 700 names, with checkboxes checked
off
almost
daily. (Depends on those that show up)



I have seperate feilds for first name and last name and date and
visit