add a specific record value to a concataneted query in expression builder

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wirejp
    New Member
    • Jun 2014
    • 77

    add a specific record value to a concataneted query in expression builder

    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”
  • wirejp
    New Member
    • Jun 2014
    • 77

    #2
    I got the issue resolved.

    Comment

    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517

      #3
      Can you post your solution in case someone else runs into the same problem?

      Comment

      Working...