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 Chriss Miller 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. danneedham

    Hierarchy Query - Single Table

    Hi Guys A Hierarchy node can be buried several levels deep. ie, Node: TOTGP - TOTAL GROSS PROFIT has several sub nodes Node: TOTSAL - Total Own Sales Node: CONSAL - Concession Sales Node: CONSAL1 - Concession Sales (1) Node: CONSAL1 -...
  2. danneedham

    Hierarchy Query - Single Table

    Hi That is great, just taking it a little further... Now if i have a child of a child eg. Nested more than one deep? Also, combining children of the hierarchy with the actual records (ie, the final elements 1s and 2s). Thanks again for your help. Dan
  3. danneedham

    Hierarchy Query - Single Table

    Hi PH Missed a column, within table two there is a Column with "NodeID". Hope this helps. Thanks Dan
  4. danneedham

    Hierarchy Query - Single Table

    Hi All I'm scratching my head a little here! Trying to mimic a function on a financial system CODA. It relates to reporting groups. I currently have to tables: Table 1, Node Parent Node ID (TEXT ID) E.G. TOTSAL1 Node Name (Text) E.G. Total Sales Table 2, Node Child ChildID (AutoID)...
  5. danneedham

    Filter String with Access VBA

    Hi All I think I have found an answer to my question. When I combine all of the filter criteria. It just required brackets: Criteria = "(" & Combo1 & ") AND (" & Combo2 &")" Etc. I think the problem was when there was more than one choice my code automatically generated Combo1 OR Combo1...
  6. danneedham

    Filter String with Access VBA

    Hi Everyone, I am trying to create a filter form to help users select the data that they would need. At the moment it consists of 3 list boxes, where multiple items can be chosen. When multiple items are chosen in some instances it doesnt return the correct data. Please help! <CODE> Sub...
  7. danneedham

    Query, Needing 2 different values...

    After much playing i've found a solution!! SELECT Sales_Sales.ID, Sales_Sales.StoreID, Sales_Sales.TDate, Sales_Sales.ADate, Sales_Sales.Amount, Sales_Sales.EntryType FROM Sales_Sales, (Core_Admin INNER JOIN Core_FinancialWeek ON Core_Admin.CUMTYFROM = Core_FinancialWeek.FinancialWK) INNER JOIN...
  8. danneedham

    Query, Needing 2 different values...

    Hi All The title doesnt really make sense, but hopefully I can expain a bit more... I am trying to create a query from two tables, admin and financial dates. TYWeekFrom 0801 TYWeekTo 0802 to query table financial dates FinancialWeek, DateFrom eg. 0801 27/01/08 0802 I...
  9. danneedham

    Advice on Table Structure

    Further advice?? Think from the above, i should hold just the actual dates in my sales table... now, i need a table to hold my financial dates... Within a financial year we have periods (the months) and then the weeks within them.... I would like the users to query either by period, or by...
  10. danneedham

    Advice on Table Structure

    Thanks PH
  11. danneedham

    Advice on Table Structure

    Hi All I am currently in the early stages of creating a sales database for work. I was planning on the main sales table to be as follows: ¦ Date ¦ StoreID ¦ Amount ¦ The main queries from this data will be on "Week No" contained within another table, or "Period No"... Am i best to have...
  12. danneedham

    Query - I need a field to equal the unbound control on the form...

    Hi This is what im trying at the moment... SELECT RTS_Estimate.Store, RTS_Estimate.Sun, RTS_Estimate.Mon, RTS_Estimate.Tue, RTS_Estimate.Wed, RTS_Estimate.Thur, RTS_Estimate.Fri, RTS_Estimate.Sat, [Forms]![Sales_week]![Week] AS Expr1 FROM RTS_Estimate; Still no luck... Have i missed something??
  13. danneedham

    Query - I need a field to equal the unbound control on the form...

    Hey Sorry i dont think i was very clear... Currently, the user will type in the year and then the week number in two unbound controlls. I need to then open up a table where two fields will be referenced to these controlls, however multiple records may be created. Does this make sense? When...
  14. danneedham

    Query - I need a field to equal the unbound control on the form...

    Hi All I hope someone can help me! I have a table, which i need two field to be automatically filled in when a new record is added. I thought i could do this through a query. I need two fields to equal the values in an unbound form. I have so far for one of the fields: Week...
  15. danneedham

    Top Status Date Per Sales Date

    bonus! Just what i was looking for!!! Thanks again! Dan
  16. danneedham

    Top Status Date Per Sales Date

    Hi Golom These tables have been created by myself, so the only columns there are: Sales StoreId, SalesDate, Amount Status StoreID, StatusDate, Status Is there no way of producing a query which takes each entry in the sales table, and searches in the status table for the max statusdate that...
  17. danneedham

    Top Status Date Per Sales Date

    Thanks for your help Golom, It appears to be coming up with a parameter box for "X.SalesDate" I promise I will be going out and buying books on queries ASAP! I didnt realise how little I knew! Thanks Dan
  18. danneedham

    Top Status Date Per Sales Date

    Hi Golom Still no luck unfortunately... it is still showing the most recent status, rater than the most recent status per sales date... The use of the sum for the sales amount is for the following. As a retail business - the tills poll their figures. If stores dont poll for whatever reason a...
  19. danneedham

    Top Status Date Per Sales Date

    Hi Golom Sorry, I did not realise... I've just tried that query but it is giving the most recent status for both sales date: StoreID SalesDate MaxOfStatusDate SumOfAmount A0001 01/01/2007 01/01/2008 100 A0001 01/01/2008 01/01/2008 200 What I was looking for was the max status date per sales...
  20. danneedham

    Top Status Date Per Sales Date

    Thanks Golom! This is exactly what i needed! You really are a star! Dan

Part and Inventory Search

Back
Top