Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ryne23

    Query Build

    Thank you, I will give it a try.
  2. ryne23

    Query Build

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

    Query Build

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

    Query Build

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

    Query Build

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

    Sub Forms

    Thanks. I will give it a try.
  7. ryne23

    Sub Forms

    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?
  8. ryne23

    Create table from folder contents

    Thank You I will give this a try. Mike
  9. ryne23

    Create table from folder contents

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

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

    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;
  19. ryne23

    Selecting last 3 dates in query

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

    Selecting last 3 dates in query

    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

Part and Inventory Search

Back
Top