Remarks does not show on report

[luzz]

Hi all, I have this issue where my remarks does not display on my report. I think there is something wrong with my query. I create the query and use SQL aggregate first on my remark so that i will only need to key in remarks on the first record and key in one time. But it appear as i key in remark on my second record. How do i fix that?

Below is my query:

SELECT MainTable.FabricDelivery, MainTable.Fabrication, MainTable.Width, MainTable.FinishedGoods, Min([MainTable.PO]) AS MinOfPO, MainTable.Colour, MainTable.LabDipCode, First([MainTable.Remarks]) AS Remarks

Image of my table:

 

[jdraw]

Your query does not have a FROM tablename

Perhaps part of your SQL was not copied/pasted correctly.
Please post a copy of your relationships showing how Maintable an Remarks are related.