Recent content by jonnyuk3

jzwp22, thanks for your help. It was the left join, i'd never used that before. Obviously still got a lot to learn!!! jonnyuk3

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

Thanks HiTechCoach, That works great. jonnyuk3

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

Any chance of giving me a clue as to how i could do this then? jonnyuk3

Thanks, I thought that may be the answer. Would it be possible using VBA? jonnyuk3

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

Thanks for the reply. What would the junction table contain then? Would it contain the sales data? Or would there still be a seperate table for the sales data. jonnyuk3

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, Thanks for your replies. I want to get away from using the combo box altogether. I just want the users to enter an empoyee number into a text box, the database then goes off and finds their record and displays their information on the form. I think I would be able to do this using VBA...

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