Search results

Can't get total row to show up on data sheet, I have 2 columns [Company Name] [Total Spend] , this is an expression I have the total row turned on and the [Total Spend] set to Sum I have the [Company Name] set to Group By I get a total spend by Company; but at the bottom of the [Total...

Query has 3 fields [Due Date], [Run Date], [Fin Date] Exp:[Due Date]-(Max[Run Date],[Fin Date]) The above is the expression that is not working in my query, below is some sample date that demonstrates what I am looking for [Due Date].......[Run Date].......[Fin Date] [Jan 20 09].......[Jan 13...

Like a glove, that's hit the spot, Thnx

I want to query a table Table has Order data as in the following sample: [M1], [M2], [Order #], [Order Qty] I want to query all the records in the table where [M1] or [M2] is equal to 22 I know how to specify the criteria in the query for one field at a time, but I have never done it like...

I have the following tables: [Production] [Excellence] The tables are linked by Machine_No I have 3 Queries based on the above Tables [Production_Query] - This Query works fine [Excellence_Query] - This Query works fine [Production_Excellence_Query] - This Query is a comination of the...

Got it on my own Private Sub UserForm_Initialize() ActiveWorkbook.Sheets("SMRF").Activate Range("A1").Select ReQuestType.Value = ActiveCell.Offset(9, 1) End Sub This Code populates the User Form with the current value that is in the spread sheet therefore you can view make changes...

I just spent a long time learning how to create a VB form that populates fields on my spreadsheet using the following type of code: Private Sub UpdateCustomerInfo_Click() ActiveWorkbook.Sheets("SMRF").Activate Range("A1").Select ActiveCell.Offset(2, 1) = Phone.Value Works Great but...

O.K, I am really trying to figure this out from other postings but my limited query experience is limting my understanding of the other posts. I only know how to use the query wiz and then a bit in design mode. I have a Query [ID]pk [Contest Name], [Score] There will be many records for the...

Report of Sum Totals O.K this does help Scott, I was able to now get the report of the information correct. I am seeing the sum of the scores by Name of Contestant perfectly. I now need to order the report by this sum total. But I can't find a method of doin so in the grouping or sorting as...

I have a table [ID]pk,[Name],[Score1],[Score2] Sample [1],[Shaun],[6],[7] [2],[Shaun],[7],[5] [3],[Andrew],[5],[6] [4],[Andrew],[6],[6] When I query for report I want the report to be as follows: Name Total Shaun 25 Andrew 23 I am missing something in my query or report not sure...

Figured it Out Sorry, pull in the Unique Key and I'm There Sorry for the brain fart.

I have a Main Form Main Form [Event],[Category],[Judge Name] The Main Form also has a subforms Sub1[Event],[Category],[Judge Name],[Score],[Comments] On the main form I have a combo box that is set to retrieve records that meet the combo selection. and thus the subform is related to display the...

Searched the threads and there seems to be a lot of info but my inexperience makes it difficult to understand, so forgive me if this is a common question: I have a Form with the following fields: [Score1], [Score2], [Score3] I also have an unbound box on this form [Sum] that adds the scores...

I have experienced this simple fix for me was to go into the properties for the sub form and change from Dyna to Dyna (inconsistent updates). This worked for me.

I have been reading this is how I am able to articulate my problem with some degree of knowledge. I have 3 tables as Follows: Table 1. [ID]pk, [Contestant Name],[Event],[Category],[Class] Table 2. [ID]pk, [Judge Name],[Event],[Category] Table 3. [ID]pk, [Contestant...

Getting there O.K I am getting there RuralGuy, you have been key Tables complete, form interface complete Next challenge is that now that i see the Parent Form and Sub Form the way i want when i update the Sub Form with [Score values] they are entered into their correct table but the other...

I am trying to have a completed project by the end of the week, to recap thank you for your help. I am redoing the database based on some of your advice. I have created the tables as above and i am working in a saved copy to try my own ideas and a good copy to save what is working.

Reply to definitions [Event] is a title "Mrs Canadian National" [Category] is "Fitness" or "Muscle" [Class] "100lb to 112lb" [Symetry] "would be a judges score for the bodies side to side symetry" [Round] "would be the judges score for the bodies roundness vs's cut" How the above relate to each...

Reply to table setup ..Judges IDNumber Name ..Events EventID Name ..Categories CatagoryID Name ..Contestants IDNumber Name ..Entry Information IDNumber Name Event Category Class Remarks ..Scores IDNumber Judge Name Contestant Name Symetry...

I have the table that contains the [Judge Name],[Event],[Category] Now i want to enter the scores for each contestant [Judge Name],[Event],[Category],[Contestant Name],[Score1],[Score2] I would love not to duplicate this info but i cant figure out how to enter the scores[1] , [2] for each...