Query off of a Query: 1st Query Will Not Add to 2nd Query

[sbf2014]

Hi everyone,

I need to run a Query off of a Query. (Query 2 off of Query 1)

Query 1 works perfectly, but it exceeds the character limit and therefore cannot be opened in design view. It can only be edited in SQL view.

When I create Query 2 and attempt to add Query 1 in design view, I can see Query 1 flash on the screen for a split second and the disappear. I cannot figure out why it will not allow me to add it.

Has anyone heard of this before? Could it have to do with the fact that it has too many characters to be viewed in the design grid?

 

[JHB]

Could it have to do with the fact that it has too many characters to be viewed in the design grid?

How many characters does it have and is it in one cell in the design view?
Never seen it before, could you post a stripped version of your database with some sample data, (zip it), + the query name where you've the problem.

 

[Galaxiom]

I presume the designer can't handle as an input if it exceeds the limit. I have never seen that before because I would never contemplate such a hideous construction.

The designer cells can contain up to 1024 characters. I can't imagine trying to deal with that.

If you have hit that limit, my guess is that you have incorrectly structured your data and are using enormous nested IIF constructs to work around the problems it causes.

 

[sbf2014]

Hi,

Yes, I am still pretty new to Access and was trying to use 'enourmous nested IIF constructs' because my boss told me he only wanted me to drastically reduce the number of queries I need to run in order to produce the reports we need. I have to do some many data transformations to the same pieces of data that continually nesting IIF statements was the only way I could make it work.

I've since abandoned that idea and have made a different solution.

Sorry, I can't upload any data because 1) it is sensitive health/insurance data and 2) I don't know what stripped/zip it mean.

Thanks for your help, guys!

 

[JHB]

...
Sorry, I can't upload any data because 1) it is sensitive health/insurance data and 2) I don't know what stripped/zip it mean.

Only for info:
Stripped version is, only a database with the needed tables/queries/forms/reports to provide the error or what else you ask for.
Zip - is a compressed file, (a zipped file).
And I only asked for sample data, not exact data.