We've just upsized our MS Acess database to MSDE and are using an Access Projects ADP front end.
Im trying to convert all our old reports to run on this new Access PRojects front end
and I'm running into problems.
In my Access Projects Report, I cannot use any aggregate functions, sum, avg in the control source of textboxes unless the control source
is a field from the stored procedure linked to the form, I was able to use these functions on any textbox in regular Access, but now
I get Error messages like "Column ???? does not exist in appropriate rowset" or "Aggregate Functions are only allowed on on output fields of the recordsource"
Im new to Access Projects but is this normal? These functions work in the control sources of textboxes in our old Access front end,
Is there a way to work around these functions not working in Access Projects
or am I going to have to code a load of Sums and Avgs etc in VBA to work these numbers out?