Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jpiscit1

  1. jpiscit1

    Help with Join

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

    Help with Join

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

    Help with Join

    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]...
  4. jpiscit1

    Help with Join

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

    Help with Join

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

    Select results based on field value of 1 or NULL

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

    Select results based on field value of 1 or NULL

    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]...
  8. jpiscit1

    Declaring a Variable

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

    Declaring a Variable

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

    Declaring a Variable

    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"...
  11. jpiscit1

    Declaring a Variable

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

    Finding TOP 3 SUMs

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

    Finding TOP 3 SUMs

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

    Could not find installable ISAM

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

    DAO with Citrix Terminal Server

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

Part and Inventory Search

Back
Top