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