Re: How do I get a total, based on dates?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

seems like a simple Totals query should work okay. just GroupBy the client
ID field, and Count the visit date field. set criteria on the visit date
field to pull only the records with dates in a specified time frame, using
Between...And...

hth


"larryo" <larryo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E641DAA2-14C8-463A-8DBD-3240621A1EF9@xxxxxxxxxxxxxxxx
I have created a database and input form for a non-profit. Among the
services
the non-profit offers, it allows 'clients' to come in once per week and
get
bag(s) of groceries from its food cupboard. When they come in, a 'date'
entry
is made in the form corresponding to the date they come in. So if a client
comes in once a week, every week of the year, there would be 52 dates
entered, and the total or 'count' or 'sum' of the visits would be 52.
However, very few of the 'clients' come in every week. But the non-profit
would like to get a tally of the number of visits within a specified
period
of time per client. So, what I would like to do, however it may be done -
either in a query or a report, is to total the number of times a client
comes
in by 'counting' or 'summing' the 'dates'. No matter what I have tried, I
just can't get it to work. Any help will be greatly appreciated
--
larryo


.

Relevant Pages

  • Re: Time Aggregate
    ... math functions to get hours or minutes if needed. ... GROUP BY Client ... > but I cannot then change to a Totals query - I get the error message about ...
    (microsoft.public.access.queries)
  • Re: varying pay rates
    ... You should be able to figure out how to calculate subcontractor cost ... Your rate table structure falls apart when the client has more than ... issue i am having is getting my totals. ... Joe Sample|Joe Professional|50|60|70 ...
    (comp.databases.ms-access)
  • Re: Help needed - want to count categories within a category on a
    ... To get a display of Education, create a totals query like: ... Age ... I need to be able to do this for ethnic group, household income, education ...
    (microsoft.public.access.reports)
  • Re: Help needed - want to count categories within a category on a
    ... Can you/have you created a totals query that displays ... Then add the subreport to the appropriate section of the main report. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Summarizing records in one table that match a different table
    ... between some of the Language Totals. ... I knew I could list a single client record in a report by tying the Client ... Previewed report as an .xls File. ...
    (microsoft.public.access.reports)