Recent content by tstowe

That is disappointing news; however, what I have decided to do for the moment is to add another field to my table effectively named positions. With each Position listed I now have the quantity available for assignment. I am first going to try to use a query to see if that will at least pop up...

Thanks for the suggestions, however I am still doing the tracking and not the dbase - if I am understanding you. To elaborate, I have the following to track Senior Tm Ldr 1 position Tm Ldr 3 positions Asst Tm Ldr 6 positions Laborer A 15 positions Laborer B 6...

I have five positions with the same title and other information and the positions are split into two at Location1 and three at Location2. What I am needing the dbase to do is: First: Understand that there are only Five positions (e.g. Five Clerks) Second: How can the dbase know when there are...

[TBL_Country Subform].Form![countryid]is correct based on what access is doing thus far.

MaxEd, The relationships are set as follows: TBL_REGION TBL_COUNTRY TBL_CITY TBL_BASE TBL_REGION has a one-to-many relationship with TBL_COUNTRY. TBL_COUNTY has a one-to-many relationship with both TBL_CITY and TBL_BASE. In TBL_COUNTRY I have the Link Child and Master Fields set to...

Glohamar, To answer your questions, I have the following forms: Region (The main form) Country Subform City Subform Base Subform No Combo boxes are used, however I do use the navigation buttons to scroll through the different regions (North America, South America, Europe, etc), once selected...

ThinkThank, What I came up with for your problem is to create a query for each of the corresponding letters. In the query design mode, right click in the lower pane and select the Totals button. In the fields I have SCORE: Group By and GRADE: SUM in the respective Total fields. Once this is...

troix, As I am just getting starting in this as well, I will offer that you place an unbound text box on your form. In that box you can do: =[score1]+[score2]+[score3]+ etc etc or you can create a query that does the math for you and then point your unbound text box back to the query. I...

I searched the posts and did not find a solution to my problem. Any help would be greatly appreciated. - The form allows the user to Select the Region (North America, Asia, etc) of interest. - Subform 1 lists all countries associated with the selected Region for the user to select. -...

I created the query and is successfully providing a SUM of the four fields for all city quantities, grouped by Country. Perfect! Now, I went back into my form and tried to pull that number onto the form and I am still getting an error message. In the field I have "=[QRY_SUM of...

I look now. Thanks. I have figured out how to show the quantity of one city from the sub-form on the form, but I haven't been able to have the field to SUM the quantities of all cities within that country onto the form. I hope that made sense. Thanks for the suggestion. I will read through...

I have three tables: Region, Country, City In TBL_City I have information that I need to perform math functions and represent in a graph (if possible) to compare the information from two separate cities. On the Form I will first select the Region (North America, Europe, Middle East, etc); in...

georgp, Your lengthy explanation was to the point and very much correct. I entered the code as you indicated above and it worked perfectly. Thanks for your time and I hope to have you answer other questions I may have. . . :) Tony

Thanks for your suggestion(s), however, how do I implement either of your suggestions? Believe me I am a definite newbie on creating access applications. Tony

I have a combo box that will have job names entered. Each job has multiple contractors that require multiple entries for each job. What I am wanting is for each new record to default to the last entered job name with the cursor ready at the first field requiring further information. Your...