P
Pearl
Have Access 2000. created query that contains 2 fields: Type (which comes
from a Lookup Table field that is combo) and RequestType (which comes from a
table that houses the actual records). The query runs fine and I get the
proper information. However, when I try to create a Chart in Reports or Form
using this query as the source, the TYPE labels are listed as 1 , 2, 3, 4
vs the proper labels (i.e. Candy, Cookies, Chips). How can I correct this?
from a Lookup Table field that is combo) and RequestType (which comes from a
table that houses the actual records). The query runs fine and I get the
proper information. However, when I try to create a Chart in Reports or Form
using this query as the source, the TYPE labels are listed as 1 , 2, 3, 4
vs the proper labels (i.e. Candy, Cookies, Chips). How can I correct this?