Recent content by alleny87

  1. A

    Newb in need of help

    I can, but not till monday.
  2. A

    Newb needs help with statistics in reports

    Is there a way of formulating statistics at the bottom of a report? Heres what i have. The report pulls Rank, Last Name, First Name, Assigned weapon, Weapon qualification date. After 6 months i use conditional formatting to highlight the soldiers qualification date red. Im in the military...
  3. A

    Newb in need of help

    I'm in the military and i created a form that displays my soldiers information, but y problem is the form i created is read only, i cant edit the values so that they update back into the database. also how do i create a drop down menu that's static at the top so i can select a soldier, and its...
  4. A

    Newb in need of some serious help in table design

    I'm relatively new to access, i have used and edited other databases, but this is my first attempt at creating my own. Im in the Military, and i am trying to create a database to track all my soldiers, and their different certifications and qualification and when they all expire. SO i made a...
  5. A

    Hiding Rows based on cell value

    I have generated a report with my entire list of personnel, and I have created a column that generates thier age based of another column using this: =DateDiff("yyyy",[Birthday],Now())+Int(Format(Now(),"mmdd")<Format([Birthday],"mmdd")) Now my question, im trying to hide the rows of those who...
  6. A

    Count column of dates older than a year

    It works, thank you, I knew I was somewhere in the ballpark. I really appreciate it
  7. A

    Count column of dates older than a year

    Hello All, So I have a report generated, listing all my companies personnel in one column and the next column has the expiration dates of a certian training certificate. My question i would like to add some statistics to the bottom of the report, mainly how many certificates are expired, which...
Top Bottom