I have a table containing a list of items that start with a number and then have text such as (4000 Utility Expense). I also have a query that asks to enter a number from the list. When entering an item I would like to enter the number and have the text portion automatically completed. Is this possible?
It would certainly be possible if the text and number were in different fields in your table. The query could then be instructed to look up the text and concatenate it. Depending on your end use (for example in a form, datasheet etc) it may be slightly different how you'd do it but it should be a fairly simple expression along the lines of [number typed] & " " & [text field from original table]