Re: Need help with expression
- From: "Rick B" <Anonymous>
- Date: Wed, 12 Oct 2005 16:27:41 -0500
Then add all them together (use a sum) and then multiply by 2.
..5 + .5 + 1 = 2 (sum)
2 * 2 = 4 (multiply by 2)
--
Rick B
"Jessica Murray" <JessicaMurray@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC7B55D2-E7B3-4008-AFCF-D7D9706FE523@xxxxxxxxxxxxxxxx
> Thank you for responding! That would be an easy fix if all the jobs were
> whole numbers....but some of them are 1/2 days (.50) already...so I need
> it
> to add the 1/2 days and the whole days by 2. Like:
>
> .50
> .50
> 1
>
> I want that to equal 4. KWIM?
>
> "Rick B" wrote:
>
>> =[somefield]*2
>>
>>
>>
>> --
>> Rick B
>>
>>
>>
>> "Jessica Murray" <JessicaMurray@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message
>> news:8423464B-4EC6-430D-B31A-324F25D13E61@xxxxxxxxxxxxxxxx
>> >I hope I'm posting this question in the right area.
>> >
>> > I've created a report from a query that shows the number of jobs per
>> > person
>> > within a date range. My boss wants me to add a field next to this
>> > "count"
>> > that will calculate 1/2 day equivilents. The jobs are in increments of
>> > .50,
>> > so I need the expression to calculate 1 or 2 into 2 or 4.
>> >
>> > Any help out there?
>>
>>
>>
.
- Prev by Date: Re: Summary Report
- Next by Date: Re: Summary Report
- Previous by thread: Re: Summary Report
- Next by thread: Re: group sections by year
- Index(es):
Relevant Pages
|
