Search results for query: *

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

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

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

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)...

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

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

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

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

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

Thanks PH

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

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??

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

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

bonus! Just what i was looking for!!! Thanks again! Dan

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

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

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

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

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