I have an Excel worksheet that shows counts of 11 Bins (column ranges) – see image – that result from one Access data set. Instead of linking from Excel, I want to do this in Access. I can create individual queries – no problem. I have created a Crosstab query for each of the 11 Bins as well. The image is of 1 of the CT queries. To get a result like the Excel result I have to then design a second query with the 11 CT results, then add each of those “rows” as a separate field. I just know that running nested queries in a query is not the right approach. While it works, it is incredibly inefficient and consumes a lot of resources. I’m certain there is a SQL solution – not UNION – where the script will perform each of the 11 crosstabs using the Bin criteria, then creating the array. I’m great at Excel and good at Access VBA, but not much experience in SQL. Please help (and be patient).

I have an Excel worksheet that shows counts of 11 Bins (column ranges) – see image – that result from one Access data set. Instead of linking from Excel, I want to do this in Access. I can create individual queries – no problem. I have created a Crosstab query for each of the 11 Bins as well. The image is of 1 of the CT queries. To get a result like the Excel result I have to then design a second query with the 11 CT results, then add each of those “rows” as a separate field. I just know that running nested queries in a query is not the right approach. While it works, it is incredibly inefficient and consumes a lot of resources. I’m certain there is a SQL solution – not UNION – where the script will perform each of the 11 crosstabs using the Bin criteria, then creating the array. I’m great at Excel and good at Access VBA, but not much experience in SQL. Please help (and be patient).

I’m working with a Microsoft Access table that stores its data in the following format:

I would like to ask for your assistance why am I getting this error:
“JOIN expression not supported”

I would like to ask for your assistance why am I getting this error:
“JOIN expression not supported”

I would like to ask for your assistance why am I getting this error:

Hi i would like to ask for your assistance why i’m getting error. “The specified field ‘t0.UserID’ could refer to more than one table in the FROM clause of your SQL statement.”

I have this table called Facturació:

I have a table with grocery items, brands, and expiration dates:

I have two tables: The first is a table of roles where each person is in a team but person c has changed teams in June: