Recent content by DavidCBzz

  1. D

    Set field Criteria to “Is Not Null” based on localvars

    Alarms...Hmmmm, I figured it may be more serious Wanted to get back to you sooner, but then I started to rethink the design. The original data for the dbase is linked to an existing Excel file; it does a lot of math, but has always had issues with the report side, hence the access part. I...
  2. D

    Set field Criteria to “Is Not Null” based on localvars

    Aloha, I have a form (with 30 accounts), were user selects check boxes; one of each day of week, then clicks a button to start the event. The event will print a report(s) for each day of the week; it is a schedule for a specific day of week, containing 5 fields from the query. Assignment...
  3. D

    Sumif to Sumproduct

    Hmm this brings back memories… havent used it in a while but I’ll give it a go:eek: ''=SUMPRODUCT((A1:A10=E1)*(C1:C10)) Although range names may work better Attached a txt file, should be able to copy/paste into excel Here is a good link, this cat went all out on the explanation of...
  4. D

    Aloha

    David here, nice to be on board. Not necessarily new to Access, know just enough to get simple DB's up and running. I've always been curious as to the detailed workings of Access, and how to implement the application effectively. I’m fairly experienced Excel user, but have reached the point...
Back
Top Bottom