Recent content by jpiscit1

Excellent! Thanks a bunch. This is what I ended with. Declare @StartDate as datetime Declare @EndDate as datetime Set @StartDate = '10/10/04' Set @EndDate = '10/16/04' select isnull(A.Machine, B.Machine) as Machine, A.work_order_no, isnull(A.partNumber, B.partNumber) as partNumber, A.[Sched...

Ahhh yes. My mistake. Ragarding unique fields: In the first table(production schedule table), the only unique field is RecordID. In the second table (Production actual table), the unique field would be date_time. As it stands now my query using: Declare @StartDate as datetime Declare...

Am I close ? select A.* from ( Select 'Spin Coater ' + LEFT(SpinCoaterNo,1) AS [Machine], work_order_no, PartNumber, SUM(Isnull(Sch1_sheets,0)+Isnull(Sch2_sheets,0)+Isnull(Sch3_sheets,0)+Isnull(Sch4_sheets,0)+Isnull(Sch5_sheets,0)+Isnull(Sch6_sheets,0)+Isnull(Sch7_sheets,0)) As [Sched Sheets]...

I am unfamiliar with this technique. Can you show an example? What is meant by "Wrap each query into derived table" Your limits are only as far as you set your boundries......

I have two queries. Declare @StartDate as datetime Declare @EndDate as datetime Set @StartDate = '10/10/04' Set @EndDate = '10/16/04' 1st Query: Select 'Spin Coater ' + LEFT(sch.SpinCoaterNo,1) AS [Machine], work_order_no, PartNumber...

Here is what I was looking for: Declare @Startdate as datetime Declare @EndDate as datetime Set @Startdate = '10/1/03' Set @Enddate = '10/19/04' Select Distinct Min(p.date_qc_inspected) As [First inspec Date], Max(p.date_qc_inspected) as [Last inspec Date], (case when auto_inspect = 1 then...

Hi. I have a table: CREATE TABLE [dbo].[prod_data_test] ( [ID] [numeric](18, 0) NULL , [date_time] [datetime] NOT NULL , [work_order_no] [numeric](18, 0) NOT NULL , [item_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [date_qc_inspected] [datetime] NULL , [auto_inspect]...

My Apoligize PHV, I did not read your post as closely as I should have. I was concentrating on OnTheFly's solution. I managed to get both solutions to work but ended up using OnTheFly's method. That worked quite well. Also thank you for the advise on naming conventions. That is something...

Thanks for your responses. I'm ok with defining the variable. I ended up calling it "operation". Lets say operation = PM1 based on the users selection. Now, I want to open a form that is already created for data entry, showing only the records whose field "operation" contains, in this case...

Under modules: Created a new Module Public Machine As String In opening form: I created an option group Added the following Private Sub Frame35_Click() Select Case Me.Frame35 Case Is = 1 Machine = "pm1" Me.Text24.SetFocus Me.Text24.Value = Machine Case Is = 2 Machine = "pm3"...

Hello everyone. I am trying to find a way that I can set a value to a variable and reference later. More specifically, I am developing a database that is linked to SQL tables. One table records problems from three different operations. Here's what i would like to see: My Welcome form (first...

Actually I read it wrong. But I think he will need the order by clause to get the top three highest counts. As follows: SELECT Top 3 Activity.Zip, Count(Activity.Zip) AS CountOfZip, Activity.Cat, Activity.SubCat FROM Activity WHERE (((Activity.Date) Between [Enter Beginning Date] And [Enter...

Try this: SELECT Top 3 Activity.Zip, Count(Activity.Zip) AS CountOfZip, Activity.Cat, Activity.SubCat FROM Activity WHERE (((Activity.Date) Between [Enter Beginning Date] And [Enter Ending Date])) GROUP BY Activity.Zip, Activity.Cat, Activity.SubCat Order BY Activity.Zip; Your limits are...

Ok. I am ready to pull my hair out on this one. I hope someone can help. I am developing an MS Access 2000 DB as a front end for a SQL 2000 DB. I am attempting to use code to dynamically connect my SQL Tables. The problem is, when I run the code I get a "Could not find installable ISAM 3170...

Hi everyone. I am currently working on an application that uses MS Access 2000 as a front end and SQL 2000 as my data warehouse. The application is configured to run on a Windows 2000 Terminal Server with Citrix MetaFrame XP. Prior to developing the application We installed MDAC 2.6 drivers...