Search results
-
F
Null field problem =Sum(Nz([Sale Price],0))
A newby is stumped. Attached is a screen shot of a report I am trying to build. I placed =Sum(Nz([Sale Price],0)) in Control Source but I am getting a blank when it should be a "0" in a number of fields. Any help I can get with this will greatly appreciated. -
F
Call subform from another subform
From a subform using a command button I want to call the corresponding form and subform. I am able to call the correct form using: DoCmd.OpenForm "Work Enter", acNormal, "", "[ArtistID]=[Screen].[ActiveForm].[ArtistID]", , acNormal The name of the subform is Work Subform... -
F
Date criteria question
When I enter a date in criteria (20-Nov-10) the return is incomplete, that is not all of the records with that date are returned. However when I enter a date (20-Nov-10) and the next day (21-Nov-10) the return is complete. Can someone please show me the way? I am lost which is not unusual for...