Expression too complex error

[bigspace55]

So, I've been using my DB for about a month or so now and it has been working fine. Then, all of a sudden I get hit with this error when I try to open up one of my queries. I'm pretty sure I need to do something with setting Parameters but I'm not sure what or how to do it. Here is the SQL of the query.




SELECT [TC12 Data with month and year].[Technician Name], [TC12 Data with month and year].MA, [TC12 Data with month and year].account_number, [TC12 Data with month and year].wo_type, [TC12 Data with month and year].create_date, [TC12 Data with month and year].le_work_order_number, [TC12 Data with month and year].work_order_number, [TC12 Data with month and year].last_event_wo_type, [TC12 Data with month and year].last_event_close_date, [TC12 Data with month and year].days_between, [TC12 Data with month and year].customer_lname, [TC12 Data with month and year].current_scheduled_date, [TC12 Data with month and year].total_tc_within_60_days, [TC12 Data with month and year].[Month Number], [TC12 Data with month and year].[Month of], [TC12 Data with month and year].[Year of]
FROM [TC12 Data with month and year]
WHERE ((([TC12 Data with month and year].[Month of])=[Forms]![Reports by selected month and/or office]![Month of]) AND (([TC12 Data with month and year].[Year of])=[Forms]![Reports by selected month and/or office]![Year of]));

In this statement, the TC12 Data with month and year is a query that has a list of data with expressions in it giving the month number, month name, and year of for each row of data since all of them have a date with them. In the query that has a problem, as you can see, I am trying to pull from that query the same data but where the month and year are equal to what I have selected on my forms.


Thanks in advance!

Had to edit this cause I put the wrong query sql in here...sorry. It's the right one now

[June7]

Can't see anything wrong with the query syntax. Could simplify:

SELECT * FROM [TC12 Data with month and year] WHERE [Month of]=[Forms]![Reports by selected month and/or office]![Month of] AND [Year of]=[Forms]![Reports by selected month and/or office]![Year of];

Does query [TC12 Data with month and year] open without error?

[bigspace55]

Yes, [TC12 Data with month and year] opens fine. I tried doing what you said and it brought up the data for a second but then it popped up as "data type mismatch in criteria expression" and every single item on every row and field ends up switching from whatever it's supposed to be to "#Name?"

[bigspace55]

Hey June...Thanks for the help. It ended up being some data typed into the table it was pulling from was messed up and not any of the queries.