Radio Buttons Help Pls!!!!!!!!

[joe]

Hai Guys,

Iam trying to develop a database for a flying club which has log the details
of all flights happened.
In this in the main form of data entry i have a radio button for the Type of
Flight of taken (SOLO or DUAL ) as a option group having two option Dual or
Solo, and i am saving the data collected from this table into main table
called AccountTable

The problem is value that is saved into table will be numeric 1 or 2
according to choice.I dont want this to happen , Is there any way i can save
to table as text like Solo or Dual?????????????

Thanks for the help in Advance...........

 

[Jeff Boyce]

Joe

Why? As in "why do you care how the data is stored as long as your form
shows "Solo" or "Dual"?"

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[joe]

Jeff
Thanks for the reply.

I need it to stored as Solo or dual bcoz iam retrieve the data from tht
table on latter stages which i needed to be shown as dual or solo.

for example.
in latter stage iam making a daily report of all flights on a particular
date ,at tht stage i want this field(Type of flight) as Dual or Solo instead
of 1 or 2

Thanks for the help

 

[Bob Quintal]

Jeff
Thanks for the reply.

I need it to stored as Solo or dual bcoz iam retrieve the data
from tht table on latter stages which i needed to be shown as dual
or solo.

for example.
in latter stage iam making a daily report of all flights on a
particular date ,at tht stage i want this field(Type of flight) as
Dual or Solo instead of 1 or 2

Thanks for the help

in the report, put an unbound textbox, set its label to "Type of
Flight". In the textbox itself you would enter
=iif([type of flight] = 1, "Dual","Solo")

 

[joe]

Thanks Buddy ...........
tht solved my problem for now........

Jeff
Thanks for the reply.

I need it to stored as Solo or dual bcoz iam retrieve the data
from tht table on latter stages which i needed to be shown as dual
or solo.

for example.
in latter stage iam making a daily report of all flights on a
particular date ,at tht stage i want this field(Type of flight) as
Dual or Solo instead of 1 or 2

Thanks for the help

in the report, put an unbound textbox, set its label to "Type of
Flight". In the textbox itself you would enter
=iif([type of flight] = 1, "Dual","Solo")