Form footer totals

J

judith

I think I have a problem with refreshing

I have a series of totals in a form footer that are showing #error#
If I change it to avg (while in form view,2003 version) it picks up
correctly but the next time I open the form it reverts to back to #error#. I
then change it to sum and it shows OK but again reverts. The form is based on
a sequence of queries that do some grouping and the form also refreshes on
some selection criteria.

Any ideas please as my next thoughts are to add the totals in a separte form
that displays under the main form

Thanks
 
S

strive4peace

HI Judith,

"The form is based on a sequence of queries that do some grouping and
the form also refreshes on some selection criteria."

Forms are generally used for data input ... as such, it is best to base
each (form or subform) on just one table. If you have totals you want
to display at the botton of the form that depend on several tables, it
would be best to put them into a subform with its own source and make
the RecordsetType = Snapshot

It would help if you would impart a bit of knowledge about your data
structure, the reason for these calculations, and what they are based on


Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 
J

judith

The forms are used for display and not input.
I have some selection filters up on a main form and these are fed into the
criteria of a query. The sub form is based on this query and the query also
uses the grouping to consolidate the data so it is all pretty standard. I am
puzzled as I have used this many times before so suspect I have just missed
something really obvious

Thanks
 
J

judith

I have a main form with combo selection boxes. The user selects their choices
.... year, geographic area etc and on selection the sub form is refreshed.

The sub form is based on a query QryFormBaseConsolidate.
An initial query QryFormBase makes data selections from a couple of
tables. Criteria are set in this query for year, geographic area - fed from
the main form combo selection.
The subform query, QryFormBaseConsolidate picks up this initial query,
QryFormBase and uses grouping to consolidate over employee.

A bit contorted but I need the user to have some really flexible selection
options

Thanks
 
J

judith

Thanks very much ... but dont worry, i have just put a totals subform in the
main form and that works fine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble with subtotal in form footer 4
Rounding numbers on unbound totals box 7
How to display the TOTAL of a sub form on the parent Form? 9
Form Footer & =sum([field]) 7
Refrencing Totals Row in datasheet 1
Grand Total on form shows #error 2
Total in form 1
Traffic light form 1

Top