Search results

I Have three tables - Product, GoodsIn, GoodsOut Product - ProductID, ProductCode, Description GoodsIn - GoodsInID, Date, ProductID, Qty GoodsOut - GoodsOutID, Date, ProductID, Qty I am trying to create a query that combines the data from these tables to give me a total of goods in and goods...

Hi, I have two tables, Product and StockTake. Product - ProductID, ProductCode, Description. StockTake - StockTakeID, StockTakeDate, ProductID, Quantity. I want a query that would return the last StockTakeDate and Quantity for each ProductID in the product table. At the moment I am using...

Hi, I have a macro that exports data to an excel spreadsheet. When i run the macro i receive a prompt saying 'The file filename already exists. Do you want to overwrite?' I dont want to overwrite the entire file but what i would like to do is overwrite the data held in sheet one of the excel...

Hi, I am trying to create a database that would store some sales figure information. We have 10 shop outlets which each have 3 chefs in them. Each chef has individual sales figures, with those being seperated into delivery sales and customer sales. Each of these chefs may be assigned to any...

Hi, I am trying to create a basic clocking in/clocking out system. I currently have two tables, these being: 1. Holds the employee information, employee number, name etc. The key being the employee number. 2. Holds the clocking in/out information. The key being the date and time the employee...