Expression from a specific record of multiple records

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I need to create an expression based on one specific record listed in a
textbox field of [Customer] but only if the record is "CSEA" There may be 50
[Customers]. I need something like:

=[Hours]*54*.15= [Customer]"CSEA" /[Containers]
What I am trying to do is muliply the [Hours] from [Customer] of "The Smith
Co" or any other customer by 54 and * .15 the customer of "CSEA" only.

I hope I didnt confuse you...Randy
 
Where does [Containers] fit in?

You could type about 6 records into a reply with the desired calculations
and we would probably not have to guess at solutions.
 
Here is an example of my report:
[Customer] [Containers] [Hours]
CSEA 0 1.0
Smith Co. 7,890 5.9
Jones Inc. 2,423 1.0

I need to take 15% of the [Hours] of "CSEA" and add to the [Hours] of "Smith
Co." and then multiply this result by $54 and devide this number into the
number of [Containers] of "Smith Co."
Thanks for your help...Randy
----- Original Message -----
From: "Duane Hookom" <duanehookom@NO_SPAMhotmail.com>
Newsgroups: microsoft.public.access.reports
Sent: Thursday, August 05, 2004 6:38 PM
Subject: Re: Expression from a specific record of multiple records

Where does [Containers] fit in?

You could type about 6 records into a reply with the desired calculations
and we would probably not have to guess at solutions.

--
Duane Hookom
MS Access MVP


Randy said:
I need to create an expression based on one specific record listed in a
textbox field of [Customer] but only if the record is "CSEA" There may
Click to expand...
be
50
[Customers]. I need something like:

=[Hours]*54*.15= [Customer]"CSEA" /[Containers]
What I am trying to do is muliply the [Hours] from [Customer] of "The Smith
Co" or any other customer by 54 and * .15 the customer of "CSEA" only.

I hope I didnt confuse you...Randy
Click to expand...
Click to expand...

Duane Hookom said:
Where does [Containers] fit in?

You could type about 6 records into a reply with the desired calculations
and we would probably not have to guess at solutions.

--
Duane Hookom
MS Access MVP


Randy said:
I need to create an expression based on one specific record listed in a
textbox field of [Customer] but only if the record is "CSEA" There may
Click to expand...
be
50
[Customers]. I need something like:

=[Hours]*54*.15= [Customer]"CSEA" /[Containers]
What I am trying to do is muliply the [Hours] from [Customer] of "The Smith
Co" or any other customer by 54 and * .15 the customer of "CSEA" only.

I hope I didnt confuse you...Randy
Click to expand...
Click to expand...
 
Please take the time to provide the results of your calculations. Do the
results appear in the detail section?

--
Duane Hookom
MS Access MVP


Randy said:
Here is an example of my report:
[Customer] [Containers] [Hours]
CSEA 0 1.0
Smith Co. 7,890 5.9
Jones Inc. 2,423 1.0

I need to take 15% of the [Hours] of "CSEA" and add to the [Hours] of "Smith
Co." and then multiply this result by $54 and devide this number into the
number of [Containers] of "Smith Co."
Thanks for your help...Randy
----- Original Message -----
From: "Duane Hookom" <duanehookom@NO_SPAMhotmail.com>
Newsgroups: microsoft.public.access.reports
Sent: Thursday, August 05, 2004 6:38 PM
Subject: Re: Expression from a specific record of multiple records

Where does [Containers] fit in?

You could type about 6 records into a reply with the desired calculations
and we would probably not have to guess at solutions.

--
Duane Hookom
MS Access MVP


Randy said:
I need to create an expression based on one specific record listed in a
textbox field of [Customer] but only if the record is "CSEA" There may
Click to expand...
be
50
[Customers]. I need something like:

=[Hours]*54*.15= [Customer]"CSEA" /[Containers]
What I am trying to do is muliply the [Hours] from [Customer] of "The Smith
Co" or any other customer by 54 and * .15 the customer of "CSEA" only.

I hope I didnt confuse you...Randy
Click to expand...
Click to expand...

Duane Hookom said:
Where does [Containers] fit in?

You could type about 6 records into a reply with the desired calculations
and we would probably not have to guess at solutions.

--
Duane Hookom
MS Access MVP


Randy said:
I need to create an expression based on one specific record listed in a
textbox field of [Customer] but only if the record is "CSEA" There may
Click to expand...
be
50
[Customers]. I need something like:

=[Hours]*54*.15= [Customer]"CSEA" /[Containers]
What I am trying to do is muliply the [Hours] from [Customer] of "The Smith
Co" or any other customer by 54 and * .15 the customer of "CSEA" only.

I hope I didnt confuse you...Randy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top