Search results

  1. C

    Open records vs closed records by weeks

    Alright gurus: Have a question for ya, I have a database that shows orders, I have 2 date fields for REQUESTED ON then another for STATUS Date as the status changes to eventually "CLOSED". What I am trying to get the DB to show me, is on week x I had XXX open records, and keep that total...
  2. C

    Access Week number Null values

    Morning all, well for me anyway! So I have a database that I am running a query that gives me the number of records closed by weeks...so I get the # of the week and the count of the closed records.... I have 1 week where no records were closed, so it is a null value, but in my datasheet it...
  3. C

    Help with a last 5 record query

    Hello all, I am in need of some help building what I believe is a complex query for a DB I am building. I have a list of "TV/SHIP" being built in a plant, these "items" go through various "AreaGroups" on various dates "complete". All of this data exists in a single table within the DB. What I...
  4. C

    Auto timeout and close function reasons

    Hello all, I have been building databases for a few years now, started after a fellow employee that has written most of our companies DB left....Tag your it! Anywho.....I have always been told that when building a multi-user network (split) DB that it is wise to build in a auto timeout (Idle...
Top Bottom