Search results for query: *

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

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

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

Hi All, I have two tables, one for sales, and one for status. I would like to get the "top" status value PER sales date. I have tried the following query but its dropping sales dates. SELECT Sales.StoreID, Sales.Date, Max(Status.StatusDate) AS MaxOfStatusDate, Sum(Sales.Amount) AS...

Hi All I'm trying to create a database I could use at work to replace the excel reports currently in place. It is a retail weekly sales report - by store and store status. I have several tables, store, store status, RTS Download (Sales Info). I download the information and import it into...

Hi All I have been pondering over this one for a while... I'm quite a basic user trying to improve the systems at work. I am trying to update the store database we currently have. It consists of two tables. Store, which holds store id, name etc. And store status, which holds status date and...