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...
...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...
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...
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...
...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...
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...
...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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.