Need help with expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 said:
=[somefield]*2



--
Rick B



Jessica Murray said:
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?
Click to expand...
Click to expand...
 
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 said:
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 said:
=[somefield]*2



--
Rick B



message
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?
Click to expand...
Click to expand...
Click to expand...
 
Eureka! Thanks a million!!!!!!!

Rick B said:
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 said:
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 said:
=[somefield]*2



--
Rick B



message
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top