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

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

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

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

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

I have a parent form that has the following [Category],[Event],[Name] In the sub form i am also storing the same values [Category],[Event],[Name] & [Contestant ID], [Score1],[Score2] I do not want to enter the [Category],[Event],[Name] each time i enter a record into this sub form i would...

To Start i have read extesively all related password protection within the site. Did not find anything exactly like this. Have Employee records with the following fields [Name] [Department] The department field is where i indicate Hourly or Salaried What i would like to do is when ever the...

Have a form with several fields within, would like all fields to be unavailable for entry until the first required field is complete. [Department] [Job] [Classification] Would like to have no access to [Job] or [Classification] until [Department] field is completed.

Simple set up, I have a Sub form titled Training that has the the following two fields: [Department],[Jobs] The jobs is a pull down select box that contains all of the job titles for the entire plant. What i would like to happen is for the user to be forced to select the appropriate...

i have a Form where i log accident reports, the reports require action / response from certain people within 3 days. my thaughts are run a query on a daily basis maybe autorun that searches for [Date initiated] that are more than 3 days old and pulls out the selected records. send the results...

O.K i know this may be a normalization problem but i need to find a way to work with what i have. Situation: Each time my AGV's move they send a data transaction to a data base that logs the Date, Time, AGV #1 Sec, AGV#2 Sec, AGV#3 Sec. Problem: I would like to know the AGV that had the maximum...

I have a query, that displays Date,Time, Station 1 Value, Station2 Value, Station3 Value, Station4 Value I would like to add to that query an expression that identifies which station had the highest value for that record.

Would like to put a box on my form that tells me how many records are in the under lying form.

I have a form with a sub form I would like to put a control box on my form that will display a certain value depending on the values in one of the fields on my primary form and another field on my Sub Form Scenario: [SHIFT] this field is on my Main Form [CURRENT SHIFT] Variable control i...

have a field on a form [Text21] Would like to use this field to set criteria on a query Tryed Forms!Form Name[Text21] But it won't work