G
Guest
I'm not sure how to do this exactly, but it seems like either Iif or After
Update someow might work.
I have two combo boxes on a form with values that I entered. The first one
is then entered into the Ad Size field. The second one is then added into
the Dimension field.
I'm thinking it would be easy for my reps if it could do the following:
if they entered FP in Adsize (for full page ad), then a 1 would show up in
the Dimension field. If they entered 1/2 H (for 1/2 page horizontal), then a
..5 would show up in the Dimension field. (in all there are about 10 options).
For reports, I need all the numeric dimensions to show up in the dimension
field. This is probably a simple question for access gurus, but it's got me
stumped.
Any help would be appreciated!!
Teri
Update someow might work.
I have two combo boxes on a form with values that I entered. The first one
is then entered into the Ad Size field. The second one is then added into
the Dimension field.
I'm thinking it would be easy for my reps if it could do the following:
if they entered FP in Adsize (for full page ad), then a 1 would show up in
the Dimension field. If they entered 1/2 H (for 1/2 page horizontal), then a
..5 would show up in the Dimension field. (in all there are about 10 options).
For reports, I need all the numeric dimensions to show up in the dimension
field. This is probably a simple question for access gurus, but it's got me
stumped.
Any help would be appreciated!!
Teri