Search results

  1. T

    I need to see total - even if it's 0!

    Hi all! I created a database to track time entry for my group. Now we're at fiscal year end and I want to get a big huge Excel spreadsheet together for my boss but I'm encountering a problem. I have some projects that are worked on every month, without fail. Others, we worked on for a month...
  2. T

    Question Is this the best way to handle changing records?

    Hi! I'm building a database that will contain all of our time entry records, and then writing reports so we can see the data in a way that is useful (as opposed to the massive Excel spreadsheets we get now that no one reads). It will be set up to be able to sort by employee, manager...
  3. T

    Question Problems with automatic update

    I am using Access 2007 on Windows XP Professional. That out of the way, here is my issue. It involves forms and reports and tables so the General forum seemed as good as any! :) I have a form that people use to enter data to a "Project Entry" table. All of my forms, reports, etc, feed from...
  4. T

    Trying to total hours by code worked

    I have a database in Access 2007 that I can upload our time entry data into. Each project has a "code" and the primary key is actually 3 fields - the employee ID, the fiscal month, and that code. I created a query to view the hours worked by code...but it shows each individual entry. So if...
  5. T

    Exporting an *updated* calculated result from a form to a report

    I'm using Access 2007 and having a bit of a problem. I have a form with a field for due date. I have an After Update event assigned to that to assign a priority code based on the distance from the current date to the due date. The priority code then appears in another box on the form. The...
  6. T

    Using DateDiff with an IIf function in Access 2007?

    Hi! I'm trying to do something fairly straight-forward, I think, but I've hit a wall. I'm using Access 2007 to create a form for project entry. My form has a date logged, a date due, and a Priority field. I figured out DateDiff so that it will tell me the difference between date logged and...
  7. T

    Question Creating a user interface in Access 2007?

    I'm just getting started with Access 2007 and I love it. I have a crush on relational databases. However, I am trying to re-create a database someone built in Access 2002. I can do queries and reports - that part is fine - but she had set up a sort of "front page" where people could click on...
Back
Top Bottom