Re: how do I get rid of "the expression you entered exceeds the 1,024-

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On 17 Apr, 20:55, KARL DEWEY <KARLDE...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
You could use more aliases but I see other problems.  
In your SELECT you have T.IndicatorID and then in the GROUP BY  
IndicatorID]. AS T -- You have a closing bracket without an opening one.  It
also is followed by a period.  And it makes an alias T of what appears to be
a field.

--
KARL DEWEY
Build a little - Test a little



"annysjunkm...@xxxxxxxxxxxxx" wrote:
Folks,
I extended the SQL below (original SQL designed by a user from this
newsgroup) but it always returning a the error msg "the expression you
entered exceeds the 1,024-character limit for the query deisgn grid".

Can someone suggest a workaround or how to get rid of error msg as I
haven't got the foggiest!

SELECT DianesBSPTourismqry.ApplicationRefNo, Y.ActualQtrDate,
Y.ActualindicatorName, Y.ActualIndicatorValue,
DianesBSPTourismqry.Programme,
DianesBSPTourismqry.OperationalProgrammeName,
DianesBSPTourismqry.PriorityName, DianesBSPTourismqry.Priority,
DianesBSPTourismqry.Measure, DianesBSPTourismqry.MeasureDescription,
DianesBSPTourismqry.DestDescription, tblRDPApplication.JobsCreated,
T.IndicatorID
FROM ((tblProjectActualIndicator AS Y INNER JOIN [SELECT
ApplicationRefNo, IndicatorID, Max(ActualQtrDate) as MaxQ
    FROM tblProjectActualIndicator
    GROUP BY  ApplicationRefNo, IndicatorID]. AS T ON
(Y.ApplicationRefNo = T.ApplicationRefNo) AND (Y.IndicatorID =
T.IndicatorID) AND (Y.ActualQtrDate = T.MaxQ)) INNER JOIN
DianesBSPTourismqry ON Y.ApplicationRefNo =
DianesBSPTourismqry.ApplicationRefNo) INNER JOIN tblRDPApplication ON
Y.ApplicationRefNo = tblRDPApplication.ApplicationRefNo
WHERE (((Y.ActualindicatorName) Like "*jobs*"));

Thanks
Chris- Hide quoted text -

- Show quoted text -

Hi Karl,
Thannks for your reply.
Here is a link to the posting of how I received the original SQL
http://groups.google.co.uk/group/microsoft.public.access.queries/browse_thread/thread/923b63d6c9a23552?hl=en#
It seems Access is adding in the square bracket and period on its own?
The original query works well as intended but I need to add more
tables/fields to retrieve more infomation and that's when it starts to
go belly up with the 1024 problem.
I am an average Access user but the complexity of this query is beyond
me.
I am hoping you might have some thoughts for a solution.

Many Thanks
Chris
.

Relevant Pages

  • Re: correlated subquery in the crosstab
    ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... I have students, courses, exam groups containing exams of courses, ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)
  • Re: correlated subquery in the crosstab
    ... I solved my problem using stored queries to act as subqueries. ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)
  • Re: correlated subquery in the crosstab
    ... The first query ... TRANSFORM FirstAS FirstOfscore ... FROM tblStudent INNER JOIN (((tblEduYear INNER JOIN tblExamGrp ON ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)
  • Re: Matching records for an update query
    ... then the update query would look something like ... UPDATE RegisteredMembers INNER JOIN BusinessChanges ...
    (microsoft.public.access.queries)
  • Re: Ranking query
    ... I expect that using a named query (as opposed to its SQL) will be OK. ... INNER JOIN qryRepairs AS I2 ...
    (microsoft.public.access.queries)