Search results

  1. V

    Suppress Groups in Reports

    I have a financial report that I have three levels of grouping for monthly expenses. Depending on how the transaction was created it can have some of the groups that contain no data. So here is are my groups Account - will always contain data Operating Unit - will not always contain...
  2. V

    vsteinly

    I have created two tables in which I want to track who and what time data is entered and then again if the table is modified. I found this code which I added to BeforeUpdate: Private Sub Form_BeforeUpdate(Cancel As Integer) ModBy = Environ("username") ModDate = Now() End Sub Private...
  3. V

    Check boxes in reports

    I have a database that has a field for methods of sustomer notification. I created a form which shows the top methods within our community. Is there a way to have all of these show up as text within a report? Maybe there is a better way to set this up to begin with but I was on a short...
  4. V

    Monthly and Yearly Totals

    I have a database that collect time and costs for projects. I have a query that looks like this. tblData.Employee tblData.Hours tblData.Rate tblData.Project tblData.Task tblValues.Pay Period I trying to get a current pay period and year-to-date for the hours and rate. I able to get the...
  5. V

    Hello Everyone

    I have been using Access since version 2002. I really should be better at it than I am. With the help of books and fourms like this, I have been able to put together many databases to help me and other get their jobs done better and faster. I can read SQL much better than I can write it...
Back
Top Bottom