Formula

  • Thread starter Thread starter Rubie
  • Start date Start date
R

Rubie

Hello,

I have this formula =>(Total Produced: IIf([TestResult]="A",1,0) in a query
and it works great. What can I add to this formula to get it to divide by 2.


For example my query results are 248 records but I want the results to show
124 records.

Any advice would be greatly appreciated.
 
Hi Duane,

Thanks for responding. I tried that and got 0.5 in each row that had 1
before and the total records remained the same (248). Any more advice would
be appreciated.

Duane Hookom said:
How about
Total Produced: IIf([TestResult]="A", 0.5, 0)
--
Duane Hookom
Microsoft Access MVP


Rubie said:
Hello,

I have this formula =>(Total Produced: IIf([TestResult]="A",1,0) in a query
and it works great. What can I add to this formula to get it to divide by 2.


For example my query results are 248 records but I want the results to show
124 records.

Any advice would be greatly appreciated.
Click to expand...
Click to expand...
 
Are you counting or summing? Counting would result in 248 while summing
should result in half of that.

Where/how are you displaying the results? If this is a query, you should
provide the entire SQL view. If this is in a report or form, you should
provide the section and control source.

--
Duane Hookom
Microsoft Access MVP


Rubie said:
Hi Duane,

Thanks for responding. I tried that and got 0.5 in each row that had 1
before and the total records remained the same (248). Any more advice would
be appreciated.

Duane Hookom said:
How about
Total Produced: IIf([TestResult]="A", 0.5, 0)
--
Duane Hookom
Microsoft Access MVP


Rubie said:
Hello,

I have this formula =>(Total Produced: IIf([TestResult]="A",1,0) in a query
and it works great. What can I add to this formula to get it to divide by 2.


For example my query results are 248 records but I want the results to show
124 records.

Any advice would be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
I'm using a query to count data from a column in a table.

Duane Hookom said:
Are you counting or summing? Counting would result in 248 while summing
should result in half of that.

Where/how are you displaying the results? If this is a query, you should
provide the entire SQL view. If this is in a report or form, you should
provide the section and control source.

--
Duane Hookom
Microsoft Access MVP


Rubie said:
Hi Duane,

Thanks for responding. I tried that and got 0.5 in each row that had 1
before and the total records remained the same (248). Any more advice would
be appreciated.

Duane Hookom said:
How about
Total Produced: IIf([TestResult]="A", 0.5, 0)
--
Duane Hookom
Microsoft Access MVP


:

Hello,

I have this formula =>(Total Produced: IIf([TestResult]="A",1,0) in a query
and it works great. What can I add to this formula to get it to divide by 2.


For example my query results are 248 records but I want the results to show
124 records.

Any advice would be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Could you respond to:
Where/how are you displaying the results? If this is a query, you should
provide the entire SQL view. If this is in a report or form, you should
provide the section and control source.
Click to expand...
We need some context to your question.
--
Duane Hookom
Microsoft Access MVP


Rubie said:
I'm using a query to count data from a column in a table.

Duane Hookom said:
Are you counting or summing? Counting would result in 248 while summing
should result in half of that.

Where/how are you displaying the results? If this is a query, you should
provide the entire SQL view. If this is in a report or form, you should
provide the section and control source.

--
Duane Hookom
Microsoft Access MVP


Rubie said:
Hi Duane,

Thanks for responding. I tried that and got 0.5 in each row that had 1
before and the total records remained the same (248). Any more advice would
be appreciated.

:

How about
Total Produced: IIf([TestResult]="A", 0.5, 0)
--
Duane Hookom
Microsoft Access MVP


:

Hello,

I have this formula =>(Total Produced: IIf([TestResult]="A",1,0) in a query
and it works great. What can I add to this formula to get it to divide by 2.


For example my query results are 248 records but I want the results to show
124 records.

Any advice would be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Hi Duane,

I'm displaying the results in a form. I have =Count(*) in my Control Source
field. I added /2 and it worked. Thanx for mentioning control source.

Thanks a lot for your help!!!

Duane Hookom said:
Could you respond to:
Where/how are you displaying the results? If this is a query, you should
provide the entire SQL view. If this is in a report or form, you should
provide the section and control source.
Click to expand...
We need some context to your question.
--
Duane Hookom
Microsoft Access MVP


Rubie said:
I'm using a query to count data from a column in a table.

Duane Hookom said:
Are you counting or summing? Counting would result in 248 while summing
should result in half of that.

Where/how are you displaying the results? If this is a query, you should
provide the entire SQL view. If this is in a report or form, you should
provide the section and control source.

--
Duane Hookom
Microsoft Access MVP


:

Hi Duane,

Thanks for responding. I tried that and got 0.5 in each row that had 1
before and the total records remained the same (248). Any more advice would
be appreciated.

:

How about
Total Produced: IIf([TestResult]="A", 0.5, 0)
--
Duane Hookom
Microsoft Access MVP


:

Hello,

I have this formula =>(Total Produced: IIf([TestResult]="A",1,0) in a query
and it works great. What can I add to this formula to get it to divide by 2.


For example my query results are 248 records but I want the results to show
124 records.

Any advice would be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top