Dear all,
I made a query with several fields, one of them is product name, and has as criteria "*"& [productname] & "*". This means when I open the query, it asks me for a part of the product name I wish to look up for in the database. All goes well until this point.
Now when I create a report based on this query, I don't get the full product name displayed, but only the "part" I put in to do the search.
Is there a way I can show the full product name in the report instead of the "part"I filled in to search for the product?
Thanks