Calculating and inserting a text item in the same space.

[littlej]

Hey There,
I have the following information in a subform. The adjustment_time is a calculated fied from the previous times also mentioned. The other items listed are from a combo box. What I am trying to accomplish is putting the time and letter in the same field. For Example:
Fields:
Begin_Time End_Time Adjustment_Time
Unscrambler Washer Filler/Stopper

Problem:
BegTime = 1200 EndTime = 1210 Adj_time = 0010
Washer = B. All this would be in datasheet format. The final result = B 0010( but we would like to use this figure for a statisical report also. Does anyone have any suggestions? Thanks for your assistance...

 

[Pat Hartman]

Only the obvious.
1. Don't combine two fields into one.
2. Don't store data you can calculate.