Recent content by rmiller

Sum of Quantities in three tables Thanks Neil You are correct, I am new to Access although I have some experience in programming. I will try this and let you know how it turns out. Rmiller

Sum data from three tables Thanks for the response. The database that I am trying to manipulate was not developed by me. In fact this is an output database that was produced as output to hourly simulation of my company's operation and there is nothing that I can do to affect the structure of...

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...

Help with Database Structure Thanks for all the great responses. Just got back from out of town. I will incorporate these wonderful tips in my database structure and let you know how it turns out. You guys are great. BTW: The publisher number is a number that appears on each piece of music...

Database structure Have one more question. For the table above tblChoirPers that describes the Choir members, what is the best option for a key. Should I use an autonumber or a combination of foreign keys (Ie ChoirID an MemberID) Or can I get by without a key in this table? What is the...

Help with database structure Thank you very much. I have made the changes you suggested. I particularly appreciated the additional information on length of table names and how to link these tables to extract the information I will most certainly need. One would have thought that there would...

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...

Query for Maximum Demand Ian THANK YOU!! You are a scholar and a gentleman! :) Rmiller

Query a table for Maximum weekly/Monthly Demand Thanks a MILLION!!! ....There is one other thing. The Database contains several years of data and this query extracts just 12 values for monthly and 53 values for the Weekly query. Is there an easy way (or not ) to report the same thing for each...

Query for Maximum demand Thank you very much. I will continue to struggle with the problem until I see the light or until someone lights a candle in my area. :) Also I don't necessarily need a single query. multiple queries would be great also.

Maximum demand query NO replies?? At least point me in the right direction. Is there a good book, a web site or a previous post that you think will help me?

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...

Browse file open Thanks for the information. Sorry I did not check first, it was my very first post. Rmiller

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...