Search results

  1. C

    What's wrong with my code?

    I have a SQL statement in a Procedure. My code works fine. I simply needed to replace this statement since I updated my query. I went to the SQL view and copied. I made the following adjustments: Replaced "AND" with "&" Replaced "INNER JOIN" with "JOIN" - because I was getting the...
  2. C

    Help with a VB code

    Hi, I have a VB code in my database which has a DISTINCTROW statement I am trying to update. Am I allowed to post it here so someone can take a look and tell me what's wrong?
  3. C

    Display query results in a form

    New to access. I am trying to allow end-users to only use buttons to navigate and display records in my database (so they don't know access is in the background) I have query that runs when they press a button but after they run it there is no way to get back to the main interface screen i.e...
  4. C

    Concatenate Email Addresses as a Query Result

    Hello, I have read through so many threads and google posts my eyes are bugging out! I am beginner access user with no SQL experience. Here is what I am trying to accomplish: I have a query which runs and produces a result of Name, Department, Region,Phone, Email, I have a parameter...
Back
Top Bottom