Search results

  1. B

    Using running sum as a field in a calculation

    I have a report that lists scores for archers using different bow types. The report groups by bow type and sorts by score. I have added a field named "LineNo" =1 and summed over groups, this gives the position of each archer within the group. I now want to divide the groups into teams, two...
  2. B

    Function NZ not recognised

    I have a new laptop with access 2010 installed using the installation disc from my previous laptop and accdb files also taken from the old laptop. I am now getting Undefined function NZ errors which I have never had before. I have checked the references and they are all the same as on the old...
  3. B

    Variables in SQL

    I am trying to update one table with a value from another table using the code below. The first statement works and gets the value from the first table. the value is displayed correctly in the msgbox. The SQL does not work as it treats the variant as a runtime input variable and asks for the...
  4. B

    Form module

    I have created many msaccess applications over the years, all using forms with modules. Recently I have tried to add a new form to an existing data base and I am getting a message "contains changes not compatible with current database format" and telling me to set the "Has module" property to...
Back
Top Bottom