Search results for query: *

Thank you, I will give it a try.

How did you modofy it. Sounds interesting. I am always looking for ways to increase spped in my databases?

My users are crazy about it. Thanks for pointing me in the right direction. Mike

Thank you it looks like it is just what I needed.

Is it possible to build a query using a form with check boxes? What I would like to do is if the field on the form is checked then it is included in the query. If it is not checked it ignored and excluded from the query. Thanks Mike

Thanks. I will give it a try.

Is there a way to link sub forms to a main form so it is only pulled up when the user enters a field that pertains to that sub form?

Thank You I will give this a try. Mike

Is there any way to create a table from the contents of a folder. For example I would like Access to read the names of all word documents in a specified folder and dump the names into a table so I can use the table in a combo box. thanks Mike

Sorry, I was working with your code on two different queries. I copied and pasted your code into the query and ran the query. It still looks like it is averaging all the dates. Thanks Mike

When I run the query as I have it below it is averaging all entries. Any ideas? SELECT Avg(EntryQry.Item) AS AvgOfItem, Avg(EntryQry.Last72Avg6Lane) AS AvgOfLane6Avg, Avg(EntryQry.Last72Standard6Lane) AS AvgLane6Standard, MainSpecTbl.Description FROM (MainSpecTbl INNER JOIN EntryQry ON...

I will give it a try and let you know. I really appreciate all your help with this. Thanks Mike

You have it right. Yes every item number will have entries but not all will be from the same dates.

The item table, MainSpecTbl, is separate from the entry table, MainEntryTbl. In the item table I have Item#, Description, UnitOfMeasure. In the entry table I have EntryDate, Lane6Avg, Lane6Standard, ItemNumber. The two tables are linked togethere by the two Item number fields. What I want to...

I have a table where all of the products that we produce are stored. What I need is to be able to pull all of the item numbers and the averages for the last three dates for each of the item numbers. Does this make sense? Thanks Mike

Hello again. I used this code and it works to pull a set number of date entries. Now what I need is to pull a set number of date entries into a query that will include a field that is called ItemNumber, and when ran will include all of the item numbers in the query with the specified number of...

Thanks a lot. I will give this a try. Mike

Here is the SQL. The date names is actually EntryDate. SELECT SpcTbl.EntryDate, Avg(SpcTbl.ItemNumber) AS AvgOfItemNumber, Avg(SpcTbl.WeightAverage) AS AvgOfWeightAverage, Avg(SpcTbl.RangeAverage) AS AvgOfRangeAverage FROM SpcTbl GROUP BY SpcTbl.EntryDate;

I am just creating the query now. I have three fields. Date AvgWeight AvgRange The data entered in will skip dates, that is where I don't know whow to write the code to pick the last three dates entered. Thanks Mike

I need to create a query that will select the last three dates entered. If the last three dates are not consecutive days is where I am having problems. Thanks Mike