Search results

  1. R

    Sum of Quantities in Three Tables

    Greetings to you all I have been struggling with a problem I thought was simple. However I am unable to solve it. I have searched the forum with no luck. I have three separate tables that have somewhat similar structures. Each have a Quantity in a specific column that I would like to sum...
  2. R

    Help with Database structure

    I am designing an application that tracks information on Choir membership and sheet music that we have on file. I am starting with a database of church members. There are four different choirs and choirs share some members. Some members of some of the choirs are also not members of our church so...
  3. R

    Query a table for Maximun weekly/monthly value

    Greetings I have a table structured as follows: ID Date WeekNo Month Day Hour Demand 1 2/12/2005 2 2 12 1 286.3 2 2/12/2005 2 2 12 2 315.1...
  4. R

    Prompting user for path and file

    I have used the folowing statement in Excel VBA path = Application.GetOpenFilename("Text Files (*.txt), *.txt,,<prompt>) to display the file opoen screen for the user to browse and select a file that is returned to the variable path. Question: Is there an equivalent Access VBA function? I...
Back
Top Bottom