Access query Error

[sneupane]

I am trying to run this query

SELECT WeeklyWorksheetTable.Style, ItemIndex.Component
FROM ItemIndex INNER JOIN WeeklyWorksheetTable ON ItemIndex.Style = WeeklyWorksheetTable.Style
GROUP BY WeeklyWorksheetTable.Style, ItemIndex.Component
HAVING ((Left([ItemIndex]![Component],3)="ZSK" Or Left([ItemIndex]![Component],3)="ZBL"));

And I am getting this error:


You tried to execute a query that does not include the specified expression'Left([ItemIndex]![Component,3])="ZSK" Or Left([ItemIndex]![Component,3])="ZBL" as part of an aggregate function

I would appreciate for any help

Thanks Sar

[pbaldy]

See if this works:

SELECT WeeklyWorksheetTable.Style, ItemIndex.Component
FROM ItemIndex INNER JOIN WeeklyWorksheetTable ON ItemIndex.Style = WeeklyWorksheetTable.Style
WHERE Left([ItemIndex]![Component],3)="ZSK" Or Left([ItemIndex]![Component],3)="ZBL"
GROUP BY WeeklyWorksheetTable.Style, ItemIndex.Component

[sneupane]

Hi paul,

I tried by using group by and gave me the same error. But I solved the issue finally. I changed the query structure. Any way thank you so much for your valuable time.

Sar