Search results for query: *

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

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

Can anyone tell me why my negative values knock off a decimal when I perform the same exact calculation on a postive value? Here's what I have: A form with 5 text boxes. Text box (TextWeightPickup) represents a net (delta) value of weight in kg. - text box is linked to SQL table Text box...

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

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

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