I am using Microsoft access 2010 and I am wondering if it is possible to add a specific record value called "credit" to a concatenated expression. When I run the query, a pop-up parameter box appears and I have input the word "Credit" in order to complete the query expression. Is it possible to modify to the parameterized query so that the user do not have to enter the word "Credit" in a parameter?
Code:
Expression 1: [CountryName] & " " & [PolicyName] & " " & [InvoiceTypePremium] & " " & Year([PolicyStartDate]) & " " & [InvoiceTypePremium]."Credit”
Comment