Access 2024 control short text (numeric)

Hello,

I’m in the process of creating a database for the condominium management council to track the management of the property manager.

Main table: (management VM) it includes the fields

date, document type (text short), (with a list of choices: estimate, invoices, email, etc.), company, (with a list of choices and the ability to add more from another table), amount, paid on (date of payment entry), etc..

I’ve already created several queries and forms, even reports that are useful to me.

I created a QUERY UNPAID INVOICES based on the starting table, I want a display by document type, that’s fine I managed to sort alphabetically, and I set the payment date criterion to NULL.. so far so good, unpaid invoices appear.

It gets complicated when I make the report based on the query UNPAID INVOICES,

the report shows numbers 1 for quote, 2 for invoices and 3 for email for the field "document type" instead of displaying the words QUOTE, INVOICES or EMAIL.

How can I display the words instead of the numbers?

oh and I forgot to mention, I don’t know why my field DOCUMENT TYPE in my database table was NUMERIC, so I changed it to TEXT SHORT but it doesn’t work any better....

Looking forward to your reply,

Marie.

thanks for your help.

- documents, (quote, invoices, email, registered letter)