Subform Does Not Display All Fields From Cross Table SQL Select

[danielleanderson80]

Hi,

I have the following SQL statement

SELECT A.REGION, A.COUNTRY, A.SITE, A.SITE_ID, A.SITE_DESCRIPTION, A.RAN_DECL, (SUM(B.RAN_TPUT)/1000000) AS RAN_DERV
FROM Asset_Value_Decl AS A, Asset_Value_Derv AS B
WHERE A.ASSET_ID1 = B.ASSET_ID OR A.ASSET_ID2 = B.ASSET_ID OR A.ASSET_ID3 = B.ASSET_ID OR A.ASSET_ID4 = B.ASSET_ID
GROUP BY A.REGION, A.COUNTRY, A.SITE, A.SITE_ID, A.SITE_DESCRIPTION, A.RAN_DECL;

which gives me the correct result when it is a Query. However, when I set the RecordSource for a subform it includes all fields from table A but excludes the summation field from Table B - thus presents first six fields only.

I also tried setting the RecordSource dynamically with VB but still no joy. I would be very grateful if you could help.

I am using Access 2000

Thank you in advance and Kind Regards

Danielle