I am trying to do a calculation which involves a number of fields from 2 tables.

Including the calculation in a query works fine but when I come to creating a form based on this query it won't allow me to create a form and subform.

Removing the calculation from the query enables me to create a form and subform. What am I doing wrong?

I hope somebody out there can help!

Thanks

Andy