Thank you!
Maybe one day I'll find the time to go through it all. I quick looked at the SQL for Query_Name2 (which I can view in design view) and it only has "SELECT" "FROM" "INNER JOIN" and "WHERE"
There are a lot of WHERE conditions but no more queries! Only tables now.
This is the sql for Query_Name, definitely more complicated:
TRANSFORM Count(Query_Name2.Field1) AS CountOfField1
SELECT Query_Name2.Field2
FROM Query_Name2
GROUP BY Query_Name2.Field2
PIVOT Query_Name2.Field3;
Yeah here it is (with some changed names). And sorry, the original query was a make table query, the one it pulls from is a crosstab query:
SELECT Query_Name.* INTO Table_Name
FROM Query_Name;
I'm not sure. It's a crosstab query and it only uses "SELECT" "INTO" and "FROM"
Access locked up again when I tried to open the query it pulls from in design view. It also only pulls from one query and one table.
I wanted to make a new query based on this old one just with changed criteria in...
Yeah I'd like to get the SQL. This is what I'm looking at. Forgive me, I only started using Access recently, but what does the "Immediate window" refer to? Thank you.
I've been trying to edit an old query that I did not design but Access stops responding when I right click it and select "design view." SQL view is not listed as an option.
I have seen some people say to retrieve the SQL code using something like this in a standard module:
Function qSQL() As...
Hi everyone,
I'm fairly new to Access but I use it frequently for my job. Lately I've been needing to edit and make my own queries and this forum has been really helpful for that. Finally made an account today.
I look forward to interacting with all of you!