Compute with Alpha Values

[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
--

 

[Duane Hookom]

Consider providing some sample records and desired report footer calculation
result.

 

[bw]

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)

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

 

[fredg]

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)

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

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.

 

[bw]

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)

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

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.

Thanks Fred!
I appreciate your help.
Bernie

 

[bw]

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)

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

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.

Thanks Fred!
I appreciate your help.
Bernie