Search results

  1. P

    Crosstab Query with Multiple Criteria

    Hello, I have some SQL code that doesn't seem to be working for a crosstab query. I have a join on two tables, and in the code below, the "Not Like "NANG"" statement works just fine, while the "Not Like "ALTCRG"" statement is not working at all. Any ideas where this might go wrong? All...
  2. P

    Adding Criteria to Append Query

    Hello, I am building an Append query and I am trying to add a way to have user added criteria to the query. I tried uploading a picture of the relationships I have, but had trouble uploading the picture, so I will try to describe it. In a table called the "Building Table" I have the field...
  3. P

    Union Query

    I am very new to access, and I am trying to move column headings into row values, and read online doing a union query would work for that. Below is the SQL code I mimicked from another person's code I had seen on a different forum. Company, py, and qtr are three already existing column headings...
Back
Top Bottom