12-05-2006, 08:15 AM #14 Brianwarnock Retired Join Date: Jun 2003 Location: Merseyside England Posts: 12,680 Thanks: 39 Thanked 533

Changing the control name had no effect, if I put in the Nz part in without =Count the results returned are blank instead of #Error. When the next product group begins, the count starts over, and "1" precedes the first item. If the property sheet is not already displayed, press F4 to display it. Access #error In Textbox You can also use this expression in the SQL property of a QueryDef object or when creating a Recordset object based on an SQL query.

I have entered criteria to prompt me for the customer number and date inputs. There is no codebehind the form and the referenced field is included in the underlyingcontrolsource query. In forms The problem does not arise in forms that display the new record. Get More Info Most fields contain data to compare before event and after event.

On my design screen, the Page Footer is above the Report Footer. Thanks for your help! Please note that you cannot then use those results in further calculations, for instance, an average of the two...what you would have to do for that is recreate the expressions in I also want to sum the field entries I have for "Quantity Shipped".

When I preview the report, my result was #Error for both. I put my fieldnames in the place of Fieldname1 and Fieldname2, I opened the property sheet and checked to see that the string was shown there as the control source, and Separate the field names with an ampersand (&). The count and sum appear on the report preview above the page footer.

Watch Queue Queue __count__/__total__ Find out whyClose How to Fix MaxLocksPerFile Microsoft Access Error InstructionsHow SubscribeSubscribedUnsubscribe2,0912K Loading...