I am using Access 2007. I have form where the user selects two dates. The form filters data for sale records between the two selected dates. I have two fields, Total and Owner in the form header. Total=Sum([price]) and count is Count =Count([price]). When the user selects 2 dates and presses Enter, the two fields stay blank. If he then clicks on either field, the two then display Price and Count.
How can I get the count and price to display after I select the two dates and press the Enter key? Any help much appreciated.