Query showing number instead of text

S

Seamus Dugan

I built a query that correctly filters and displays all
fields except one. That field originated in a combo box
that became part of a subdatasheet. When the query is run,
the field shows up as a number rather than as the data it
should be. I looked back and found that the number
represents the field's position in the list from the
original combo box; for instance, if "ABC" was the fifth
choice in the combo list, the number 5 showed up in the
field when the query was run.

By the way, I appreciate the help I have gotten here,
especially from Mr. Vinson. I'm a small businessman trying
to do my own database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top