Search results for query: *

You are good. I have one case where I have a 3-way tie for 2nd and it writes 4 for each rank, but I did not ask for a method for handling ties... you gave me exactly what I asked for. Your help is greatly appreciated. You definitely deserve a star.

I might not have read your post close enough... Can't you just do 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...

I have this: mdate mshift mmachine mQty 01/01/2004 1 machineA 50 01/01/2004 1 machineA 25 01/01/2004 1 machineA 15 01/01/2004 1 machineB 65 01/01/2004 1 machineB 45 01/01/2004 1 machineB 15 01/01/2004 2...

TotalTime is the sort criteria... I appreciate all your help so far, I may post the query I eventually use along with any follow-up questions... just to make sure that I am on the right track.

oh, and make sure that the field you are looking at is the tbl1.field1 or else you will not see what you want to see.

Maybe I am not understanding you... If you make put tbl1 on the left and tbl2 on the right... then create your joins from tbl1 to tbl2... then right click the first join line and select "join properties"... then select option #2 for join type... If you do that for all of the joins between...

What I mean to say is... is there a way to use nested select statements instead of creating a giant Union table. I need the process to be automated because there will be way too many entities to put into a union table.

I have had a lot of trouble with this particular query. Here is what I want... The 3 largest downtime reasons for each date, shift, machine combination. I have a table that has these fields: tbl1ID date shift machine I have a 2nd table that has these fields: tbl2ID...

Thanks rac2. I gave you a star. I appreciate your assistance. Now, I have a starting point.

Ok, I know how to display the information from multiple linked tables in the query. In some queries I can actually modify the table entries. What are the rules that govern this capability? Where can I read about how I can setup complex queries to modify the table entries?

I am using Access 2002. I have been trying to find the proper source information to read on this topic. I am not finding it. I want to use a query to edit my table Production Speeds. I want to the query to list all machine/product combinations in a production group and provide the ability to...

Thanks to you both.

I am relatively new to VBA. I have had no formal training and I do not expect to get any in the near future. Is it bad to declare a variable inside an if then statement? for example: if x = 1 then Dim Series1 Set Series1 = operatorChart.SeriesCollection.Add end if Set Series1 = Nothing...

I am giving you a star trucap good job.

Ok, here is what is happening... I link an excel spreadsheet that someone else generates into an access database using the import... link option. The date exists in 3 columns in the spreadsheet (year, month, day). Each column is formated as a number in the excel spreadsheet. I believe they...

I have been out of town. I will look into all suggestions and respond with a detailed email. If I remember right, I build the date field from 3 separate columns in an excel spreadsheet linked to the database. (I do not have control over the excel spreadsheet.) I think I use dateserial(year...

I have a field in a query that is filled with values formated like this: format(mDate,"mmm") where mDate is a date. I want to Limit the values to only "Jan". If I put "Jan" in the criteria section I get a type mismatch error. I understand why, but what can I put in the criteria section...

Thanks Golem, I gave you a star. I had everything but the highval = rs1.Fields(0).Value after the rs1.MoveFirst Most appreciated.

I am putting a recordset values into a string, but I am having a little trouble storing the highest value into a variable. The type of rs1.Fields(0).Value is Variant/Double. I thought I could do something like: Dim Highval if highval < rs1.Fields(0).Value then highval = rs1.Fields(0).Value...

You are a gentleman and a scholar. Many thanks. Have a star