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!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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

    ...now my query using: Declare @StartDate as datetime Declare @EndDate as datetime Set @StartDate = '10/10/04' Set @EndDate = '10/16/04' select A.* from ( Select 'Spin Coater ' + LEFT(SpinCoaterNo,1) AS [Machine], work_order_no, PartNumber...
  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

    ...records whose field "operation" contains, in this case, PM1. The record source for the form uses a Select statement that looks like this: SELECT * FROM [NCR Main Table] I assume I would need to add something like... WHERE operation = ???? What would I put in Place of the question marks...
  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...
  16. jpiscit1

    Help with Automating VB code

    I have some code I am looking to execute on start up of my Access database. The code enables me to run a DSN-Less connection. It requires the following input parameters: FixConnections "MyServer", "MyDatabase" The actual code can be found at...
  17. jpiscit1

    Negative Values in MS Access

    ...what I do the calculation for the negative keeps knocking of a decimal place. Here is the calculation I am using: =([TextUSLKg]/[TextWeightPickup])*100 You would assume (.030/0.783)*100 = 3.83% and (-.030/0.783)*100 = -3.83% But I am getting: USL (+) 3.83 LSL (-) 3.8 If the calculation...
  18. jpiscit1

    Help with ODBC Connection

    Randell, Thanks, I think. Not really sure what to do with that. There are 3 postings. Are all three the code that is needed? Where does it go Access? Where do i set the references to my server, PW, UN ,etc... This link talks about setting it up automatically but does not tell you where...
  19. jpiscit1

    Help with ODBC Connection

    Im familiar with the linked table manager tools. But I am more interested in how I can refresh my tables on start up ? Can you instruct me on how to proceed with that ? Thanks John Your limits are only as far as you set your boundries......
  20. jpiscit1

    Help with ODBC Connection

    Hello everyone. I relatively new to MS Access and ODBC connectivity. I developed a MS Access interface that is used to connect to our SQL server systems. All of the tables are Linked tables (to the SQL Server). Here is my problem: Sometimes when I make a change to something on the SQL system...

Part and Inventory Search

Back
Top