Search results

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

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

I got it!!!!!!! Play around long enough and your bound to get it. Here's what I did. Union query: SELECT Rollnmbr as RN, AG_B_R1 as Num FROM dbo_ADC_Ag_B_Res UNION ALL SELECT Rollnmbr, AG_B_R2 FROM dbo_ADC_Ag_B_Res UNION ALL SELECT Rollnmbr, AG_B_R3 FROM dbo_ADC_Ag_B_Res UNION ALL SELECT...

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

Also....... How would I take this statement and link it to my form? I would think that I need another column to be my Rollnmbr. How is this written in Access? I cannot view the Query in Design mode to add another column. Something like this? SELECT Rollnmbr FROM MyTable, SELECT R1 as Num FROM...

It Works!!!!!! Thanks Jon. It works great. You saved us a lot of time:)

kindda there - but not quite WE know the following works in T-sql. SELECT STDEV(t.p) FROM (SELECT R1 p FROM MyTable WHERE rollnmbr = '0508-1' UNION ALL SELECT R2 FROM MyTable WHERE rollnmbr = '0508-1' UNION ALL SELECT R3 FROM MyTable WHERE rollnmbr = '0508-1' UNION ALL SELECT R4 FROM...

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