Recent content by ryne23

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