Compute with Alpha Values

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

Consider the following control in a Report Footer:
="Direct Total = " & Sum([PDSeats])

I want to allow [PDSeats] to have an alpha value which is computed as a
value zero(0) in the Sum function, but still displays and the alpha value on
the body of the report.

Can someone explain?

Thanks,
Bernie
--
 
Consider providing some sample records and desired report footer calculation
result.
 
Thanks for the suggestion, Duane.
I hope this is what you meant.

Sample of [PDSeats] Values and how they print on the report
49
35
E
22
E
14
Sample Footer using "Sum([PDSeats])
Direct Total = 120 (sums only the numeric values)




Duane Hookom said:
Consider providing some sample records and desired report footer
calculation result.

--
Duane Hookom
MS Access MVP

bw said:
Consider the following control in a Report Footer:
="Direct Total = " & Sum([PDSeats])

I want to allow [PDSeats] to have an alpha value which is computed as a
value zero(0) in the Sum function, but still displays and the alpha value
on the body of the report.

Can someone explain?

Thanks,
Bernie
Click to expand...
Click to expand...
 
Thanks for the suggestion, Duane.
I hope this is what you meant.

Sample of [PDSeats] Values and how they print on the report
49
35
E
22
E
14
Sample Footer using "Sum([PDSeats])
Direct Total = 120 (sums only the numeric values)

Duane Hookom said:
Consider providing some sample records and desired report footer
calculation result.

--
Duane Hookom
MS Access MVP

bw said:
Consider the following control in a Report Footer:
="Direct Total = " & Sum([PDSeats])

I want to allow [PDSeats] to have an alpha value which is computed as a
value zero(0) in the Sum function, but still displays and the alpha value
on the body of the report.

Can someone explain?

Thanks,
Bernie
Click to expand...
Click to expand...

If the field is storing letters and numbers it is a Text datatype
field.
=Sum(Val([PDSeats]))

will sum only those records where the number value precedes (or
doesn't have) a letter.
35
45E
B
A25
Total shown will be 80.
Click to expand...
 
fredg said:
Thanks for the suggestion, Duane.
I hope this is what you meant.

Sample of [PDSeats] Values and how they print on the report
49
35
E
22
E
14
Sample Footer using "Sum([PDSeats])
Direct Total = 120 (sums only the numeric values)

Duane Hookom said:
Consider providing some sample records and desired report footer
calculation result.

--
Duane Hookom
MS Access MVP

Consider the following control in a Report Footer:
="Direct Total = " & Sum([PDSeats])

I want to allow [PDSeats] to have an alpha value which is computed as a
value zero(0) in the Sum function, but still displays and the alpha
value
on the body of the report.

Can someone explain?

Thanks,
Bernie
Click to expand...
Click to expand...

If the field is storing letters and numbers it is a Text datatype
field.
=Sum(Val([PDSeats]))

will sum only those records where the number value precedes (or
doesn't have) a letter.
35
45E
B
A25
Total shown will be 80.
Click to expand...

Thanks Fred!
I appreciate your help.
Bernie
 
fredg said:
Thanks for the suggestion, Duane.
I hope this is what you meant.

Sample of [PDSeats] Values and how they print on the report
49
35
E
22
E
14
Sample Footer using "Sum([PDSeats])
Direct Total = 120 (sums only the numeric values)

Duane Hookom said:
Consider providing some sample records and desired report footer
calculation result.

--
Duane Hookom
MS Access MVP

Consider the following control in a Report Footer:
="Direct Total = " & Sum([PDSeats])

I want to allow [PDSeats] to have an alpha value which is computed as a
value zero(0) in the Sum function, but still displays and the alpha
value
on the body of the report.

Can someone explain?

Thanks,
Bernie
Click to expand...
Click to expand...

If the field is storing letters and numbers it is a Text datatype
field.
=Sum(Val([PDSeats]))

will sum only those records where the number value precedes (or
doesn't have) a letter.
35
45E
B
A25
Total shown will be 80.
Click to expand...

Thanks Fred!
I appreciate your help.
Bernie
 
Back
Top