I'm not sure what you mean. Still pretty new.
"Jeff Boyce" wrote:
> Add a field into your query. Use the IIF() function to derive "Male" or
> "Female", based on the #.
> Use that new field instead of the # field.
> Jeff Boyce
> Microsoft Office/Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11788-combo-box.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788
> "Jamie" wrote in message
> >I have recently taken over a database designed by someone else. I would
> > to make a report using a combo box that was set up using a # to identify a
> > field. I would like to show the value instead of the # in my report (eg.
> > 1=Female, 2=Male).When I create the query only the number shows. How do I
> > do
> > this. I would like to keep the # for inputing as it is easier than typing
> > in
> > the value.
> > Any help is greatly appreciated. Thanks. Jamie