Search results

  1. S

    Max and Min of unbound text boxes

    I have a form with about 100 unbound text boxes. How do I get the Max and Min values of these boxes? I spilt these boxes into groups of 10 and I need to find the Max and Min values of each group of 10? I was hoping not to have this calculation run in VB because there is alot of other code...
  2. S

    Check query to see if record exists

    Hello all, I have a form that looks at my "master table" where users put in general info about a sheet of material. There are two combo boxes on this form, Batch# and Lot#. They will use the same Batch# and Lot# for many sheets. Every time a new batch and lot are entered, this will bring up a...
  3. S

    Update next record while still on current

    I have a form(F_Roll) that runs from a query(Q_roll) which asks the user to input the date. New records are made from this form, and it also allows the user to look at the records from past dates. On this form, my next button creates a new record for that date and fills a field called...
  4. S

    Input Criteria into Union query from a Form

    Based on information from a earlier thread.... I created a Union query that pulls information from multiple tables and fields. SELECT AG_B_R1 as Num FROM dbo_ADC_Ag_B_Res WHERE Rollnmbr=[roll] UNION ALL SELECT AG_B_R2 FROM dbo_ADC_Ag_B_Res WHERE Rollnmbr=[roll] UNION ALL SELECT AG_B_R3 FROM...
  5. S

    STDEV arcoss multiple fields/tables

    Below is a Tab Delimited section of text to represent a SQL Table. This is the result set of a select * from table where RNmbr = 0508. I added the Top Row of A TAB B…TAB H Row 1 references Column names of SQL Table. And the First Column (under A) as Excel references. A B...
Back
Top Bottom