Re: Counting a person's actual work days

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

A Query in which you specify Unique values will allow you to obtain the
count you want. In the Query Builder, right-click on the upper part but not
on a table or join line, then choose Properties, and set "Unique Values".

Larry Linson
Microsoft Access MVP


"Kevin0862" <Kevin0862@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EBE48454-9EFF-4CFB-A6E0-10AB4B1D40FC@xxxxxxxxxxxxxxxx
>I have this problem where the date fields are in text format, and I'm
>trying
> to count the number of a person's work days.
>
> Date Current Output Count Required Output Count
> 4/1/2005
> 4/1/2005
> 4/3/2005
> 4/4/2005
> 4/4/2005
> 5
> 3
>
> Can I write a formula in the report to get the correct count or should I
> work on this in a query.
>
> Any assistance will be appreciated.
>
>


.

Relevant Pages

  • Re: Creating index with upper function
    ... >> Ian Michael Gumby wrote: ... >> The basic question still is relevant: Why the hell is UPPER variant? ... > But what's the cost? ... > insensitive query, yet may want to also retain the case sensitive ...
    (comp.databases.informix)
  • Re: Please help extracting records
    ... we are trying to find out the "Na" level (per patient) that is higher than ... I made a calculated field to calculate 0 (if Na value was less than Upper ... I am not able to run the query this way, ...
    (microsoft.public.access.formscoding)
  • Re: Convert Names to Upper Lower format
    ... > I have names/addresses in either all upper or all lower or mixed,. ... > Somehow at one point I figures it out in an expression in a query but can ... In a query you can use ... However, in all probability, by changing van den Steen to Van Den ...
    (microsoft.public.access.queries)
  • Passing list box results to query criteria
    ... I often use multiple combo boxes in conjuntion with the query builder to ... First criteria line: Is Null ...
    (microsoft.public.access.modulesdaovba)
  • Re: Subform problem with LinkMasterFields
    ... I always put only the fields I need in a query and never seem to use the *. ... Sometimes the query builder will put a field in twice when the field is one ... SELECT tblJob.* FROM tblJob ORDER BY ... The LinkMasterFields property setting has produced this error: ...
    (microsoft.public.access.forms)