Recent content by phenley

Arnelgp had it so it would properly work. I was having the issue where it wouldn't filter out the criteria "ALTCRG" in the where statement. All I had to do was change the OR statement into an AND one, and it properly used the criteria. Thanks for the help!

Still doesn't seem to be working, the ALR part is working as with the NANG, just not the ALTCRG

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...

I'm pretty sure it's set up the way you're describing. There is one historical dataset table in Access that gets appended every quarter with the new data, which is appended each quarter by one user. All queries to view the data are created from this table. The data is given in Excel and...

I think I may be a little confused by your question. The user will be given about 200-300 rows of data each quarter in excel. The user then imports that data into the access Building Table, which has the same fields as that in excel. Then, the user runs an append query to add that to the...

Every quarter, new data is calculated and added into to the table I am trying to append to. The data is in excel and is not the exact same format as the data table, so I import it in from Excel into the building table and then use an Append query to add it to the data table.

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...

I have a query that calculates the sum to get all the SumOf... values. In the whole data table, I have the field names Cicos, Csdr, .... with numbers occupying those values. I also have qtr as a field name which contains dates in it. I then have one query that pulls dates past a certain point...

That worked perfect, thanks! I also had to put brackets around the query name since it contains a space in it. I ran a crosstab query after this union query, since I wanted all of those field names as values, but if I just started with a crosstab query, it would only allow one field value at a...

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...